Re: Export via pipe ksh script

[Scott Shafer]

Title: Export via pipe ksh script

From http://www.orafaq.com (in the sig for this list):   <begin>   Can one export to multiple files?/ Can one beat the Unix 2 Gig limit?   From Oracle8i, the export utility supports multiple output files. This feature enables large exports to be divided into files whose sizes will not exceed any operating system limits (FILESIZE= parameter). When importing from multi-file export you must provide the same filenames in the same sequence in the FILE= parameter. Look at this example:            exp SCOTT/TIGER FILE=D:\F1.dmp,E:\F2.dmp FILESIZE=10m LOG=scott.log   Use the following technique if you use an Oracle version prior to 8i:   Create a compressed export on the fly. Depending on the type of data, you probably can export up to 10 gigabytes to a single file. This example uses gzip. It offers the best compression I know of, but you can also substitute it with zip, compress or whatever.           # create a named pipe         mknod exp.pipe p         # read the pipe - output to zip file in the background         gzip < exp.pipe > scott.exp.gz &         # feed the pipe         exp userid=scott/tiger file=exp.pipe ...                                                                                    Contributed by Jared K Still   Read the Oracle/Unix FAQ for more examples on using Unix pipes.   <end>   Check it out.    --Scott   ----- Original Message ----- From: Thomas Jeff To: Multiple recipients of list ORACLE-L Sent: Thursday, January 03, 2002 6:35 PM Subject: Export via pipe ksh script Could someone please send me a ksh script for doing imp/exp via a pipe. We're running AIX 4.3.3.    Thanks! -------------------------------------------- Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba --------------------------------------------