One thing I have found is that the pipe can get messed up if anything goes wrong with the import or export. I always recreate the pipe before each run to make sure it is clean. (pipe cleaner?)
Ron -----Original Message----- Sent: Monday, January 14, 2002 10:15 AM To: Multiple recipients of list ORACLE-L 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" <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 5:00 PM > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Smith, Ron L. INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
