Re: Exporting thru a pipe

The script is on the Lazy DBA website, but I have been having trouble with it. Look on Metalink for ways to do this.

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 10, 2002 5:00 PM

>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, January 10, 2002 23:20
>
>
> >
> > I know someone had the script because I've read it here, but at the
> time it
> > was on little interest since an export did not take that much space.
Well
> times
>
> this is from Metalink:
>
> ==============================
> o How do you create a compressed export file?
>
>
> 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.
>
> Please note, this method should be thoroughly tested before being
> implemented.
>
> - To create a compressed export file:
>
> 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>
> ==============================
>
>
> hth,
>
> Marin
>
> ----
> "...what you brought from your past, is of no use in your present. When
> you must choose a new path, do not bring old experiences with you.
> Those who strike out afresh, but who attempt to retain a little of the
> old life, end up torn apart by their own memories. "
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marin Dimitrov
> INET: marin.dimitrov_at_sirma.bg
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).