Exporting a table using MKNOD (On the fly zipping and exporting a table)
Note:
This method is mainly useful when the table size is huge and when we want to export the big table to a file system where limited space is there. This option will ZIP the export dump on the fly and will take the export. This is a really useful method of exporting where space constraint is there in underlying file system.
Steps
1)
mknod mknod_tmp p
2)
gzip < mknod_tmp > exp_SID.dmp.gz &
3)
exp parfile=parfile.par file=mknod_tmp log=exp.log
Example (Full Export) — Can be used for tablelevel and any object level accordingly
mknod mknod_tmp p
gzip < mknod_tmp > SID_full-15thMar2011.dmp.gz &
exp parfile=parfile.par file=mknod_tmp log=SID_full-15thMar2011.log
parfile.par
userid=’/ as sysdba’
full=y
consistent=y
direct=y
statistics=none
