Re: Exporting thru a pipe

From: Marin Dimitrov <marin.dimitrov_at_sirma.bg>
Date: Thu, 10 Jan 2002 14:21:30 -0800
Message-ID: <F001.003ED2B1.20020110140031@fatcity.com>

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).

Received on Thu Jan 10 2002 - 16:21:30 CST