Oracle Database Discussions

Hello,

I try to use data pump to export a core application schema. (10Gdb 10.2.0.4)

I use 'estimate' parameter of expdp before real export, and get future dump file size
will be 235GB.

the only issue is that my largest file system size is 34GB, so seems like I have to use
pipe to zip while exporting...

the action plan is like below:

1 make a unix pipe

$ mknod /faj29/appl/oracle/exports/scott1 p

2.driect pipe to .dmp

nohup gzip -5c < scott1 > /faj29/appl/oracle/exports/ODS.dmp.gz & ===>quesiton is here?


3. create a par


userid=system/password@dbname
SCHEMAS=xxx
DUMPFILE=scott1
LOGFILE=dpump_emrgods:exp_xxx.log
COMPRESSION=NONE
CONTENT=ALL
ATTACH=xxx.EXPORT.job


nohup expdp PARFILE=exp_xxx.par &

#########

My quesiton is based the information I provided, (34GB filesystem size vs 235GB dumpfile size)
how much zip extent shoud I use?
gzip -5c or gzip -9c


seems like -9c is very time consuming, this why I don't like to use it. but I don't know
zip ratio, so any friend knows?

or do we have better way to do this task?

(seems like I can not use parallel export by using pipe, if yes, how?)


thanks a lot

Jerry

Edited by: jerrygreat on May 8, 2009 9:00 AM