RE: Export Split Script

1. Create a Pipe , say usr1.pipe. A pipe is a FIFO structure. /bin/rm /dsk1/usr1.pipe /bin/mknod /dsk1.usr1.pipe p ( See your version of UNIX - mknod differs in its usage - i mean the syntax - some strains require that u mention -p )
2. Let compress listen at one end of the pipe. cat /dsk1/usr1.pipe |compress >/dsk9/usr1.dmp.Z & In the above step while making compress listen to one end of the pipe - you are also sending its output to a different file. So, compress captures data at one end of the pipe and as and when it encounters data it compresses it and sends it to an output file. Make sure to run it in background.
3. Now do an export - in place of the export dump file mention the pipe. By doing this exp will be putting data at one end of the pipe ( and compress will be taking data at the other end) exp / file=/dsk1/usr1.pipe buffer=64000 2> usr1.log

While importing, In a similar fashion, let uncompress listen at one end while imp TAKES data at the other end.

Rajaram
The value of an idea lies in the using of it. - Thomas Edison

-----Original Message-----
From: Armstead, Michael A [SMTP:maa25681_at_GlaxoWellcome.com] Sent: Wednesday, May 16, 2001 4:04 PM

To:     'ORACLE-L_at_fatcity.com'
Cc:     'rajaram_k_at_netzero.net'
Subject:        RE: Export Split Script

Rajaram,

Please give me details on how to use mknod to split export files larger than
2 GB. We have broken our jobs into over 50 separate export jobs on the table
level just to keep our files less than 2GB.

Michael Armstead
Application Database Administrator, OCP-Certified US Pharmaceuticals IT
Glaxo SmithKline

> -----Original Message-----
> From: Rajaram [SMTP:rajaram_k_at_netzero.net]
> Sent: Wednesday, May 16, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Export Split Script
>
> If you are using Oracle on Unix , You may want to use unix pipes (
mknod).
> - most people use this method to manage files > 2GB.
>
> Rajaram
> (Now that I am at the top of a mountain - I dont know how to get down!)
>
> -----Original Message-----
> From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> Sent: Wednesday, May 16, 2001 3:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Export Split Script
>
> I tries using a compressed export and the output is still over 2G. Does
> anyone have the export script that splits the export files into multiple
> files?
>
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>
>
> NetZero Platinum
> No Banner Ads and Unlimited Access
> Sign Up Today - Only $9.95 per month!
> http://www.netzero.net
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rajaram
> INET: rajaram_k_at_netzero.net
>
> 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).

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: rajaram_k_at_netzero.net

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