Re: Export to compressed files?

Ever thought about using split ? We have done it before,   it goes something like this:

  exp userid=/ full=y file=NamePipe compress=y &   cat NamePipe | compress -v > | split -b 1024M - ./full.dmp.Z

  This should generate several compressed files with 1 GB each.   

  When you import you can do something like this:

  zcat full.dmp[a-z] > full.dmp.p &
  $ORACLE_HOME/bin/imp "USERID=SYSTEM/MANAGER BUFFER=256000 FULL=Y FILE=full.dmp.p LOG=full.imp.log Received on Thu Nov 14 2002 - 15:25:55 CST