Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: EXP ....FILE=(pipe to compress)

Re: EXP ....FILE=(pipe to compress)

From: Tommy <tcusan_at_yahoo.com>
Date: Fri, 23 Oct 1998 16:45:15 -0700
Message-ID: <3631231B.7B732A0@yahoo.com>


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.

  1. Create a unix named pipe :

  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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US