Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP ....FILE=(pipe to compress)
If you have calculated the size of the file your export will produce and
it is too large to fit onto disk, you may want to consider producing a
compressed export file as an alternative to exporting directly to tape.
Again this method should be thoroughly tested before being implemented.
os> mknod /tmp/exp_pipe p
2. Start compress in the background reading in from the named pipe,
writing out to 'export.dmp.Z' :
os> compress < /tmp/exp_pipe > export.dmp.Z &
3. Start the export, specifying the named pipe as the output file :
os> exp file=/tmp/exp_pipe <other options>
Jorge Meirim wrote:
> Try www.oramag.com and the read one of the 2 flavours about this subject.
> (One use mkfifo and other one mknod).
> "This is not the fish... but intends to be the line and..."
> J. Meirim
>
> BJ Miller escreveu na mensagem <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 Fri Oct 23 1998 - 18:45:15 CDT