How to compress the export on the fly

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

  • April 24, 2012 | 55 views