Good Morning,
I need to arrange an export and at the same time compress the result,
I want to do this in a shell script, at the moment I use this

exp sc/sc@ab1 PARFILE=exp_param.dat FILE=ciao.dmp LOG=ciaolog.txt
and I also have no result with the following form

exp sc/sc@ab1 compress=y PARFILE=exp_param.dat FILE=ciao.dmp
LOG=ciaolog.txt

Thanks for your help

Antonio D'Ottavio
www.etantonio.it/en

etantonio (AT) libero (DOT) it schreef:

Do NOT use compress=y on the export command line as parameter - it will
ruin your space allocations, not compress your generated output.
What errors do you have?

etantonio (AT) libero (DOT) it wrote:
Try exporting to a pipe and then have compress read from the
pipe...similar to the following:

mknod exp.pipe p
exp u/p@tns parfile=my_parfile file=exp.pipe log=exp.log &
compress < exp.pipe > my_dump.compressed &

Alternatively, this works great with gzip. The last line would be:

gzip < exp.pipe > my_dump.gz &

To import, uncompress into the pipe and have imp read from the pipe.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Frank van Bortel wrote:
Antonio, the exp parameter compress has to do with how Oracle
calculates the initial extent size in table/index storage clauses. The
default is "compress=y" and this results in Oracle calculating the
initial extent as the full allocated size of the object which can cause
problems when you try to import the file into test environments. I
usually code an explicit compress=n so that if I use the export table
definition and load it the table takles as little space as possible.

To compress the export file either export into a named pipe as another
poster suggested and have the OS compress utility feed off the pipe or
just write the file and run compress on it after the export operation
completes.

HTH -- Mark D Powell --