Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP ....FILE=(pipe to compress)
Previous answers are true - I always run the compress as the background
process, there's less to go wrong with it.
HOWEVER... test this (will the import work?) before you rely on it. For instance, it does not work on some versions of Sequent Dynix (I can't remember which), as the (uncompressed via pipe) file looks wrong to import.
Also Oracle support won't help you as they can (probably correctly) blame it on the compression program.
E.
>make a pipe using
> mknod exp_pipe p
>
>then use this command
> (cat exp_pipe | compress > mybackup.Z &); exp file=exp_pipe ....
>
>you can also use gzip if you want to as well. You can still tape it off ...
>but if you have a fast CPU then this will speed it up (a little).
>
>Thor HW
>
>BJ Miller wrote in message <700heq$7th$1_at_cletus.bright.net>...
>>Hi,
>>
>>I have a problem at a customer site with EXP. They are unable to export to
>>disk due to filesize limitations (2G) and they are exporting to tape
>>(SLOW!). In researching possible solutions I read on a private newsgroup
>>that someone was able to 'pipe it to a compress', however EXP doesn't
>>exactly respond to the normal shell manipulations.
>>
>>Is there a way in Unix to specify an in-line compress?
>>
>>Thanks in advance,
>>
>>BJ
>>
>>
>
Received on Sat Oct 24 1998 - 14:53:22 CDT