Thursday, January 30, 2014

How to compress the export on the fly

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

No comments:

Post a Comment