You can do dbv on the zipped file and it's amazing how many errors will it report.....
> -----Original Message----- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 9:20 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Background jobs inUnix > > > can you actually do dbv on a zipped file??? > > --- Guy Hammond <[EMAIL PROTECTED]> wrote: > > Is there a way to make pipes work with dbv? I get error > 100, file not > > accessible when I do > > > > $ mknod /tmp/pipe p > > $ dbv file=/tmp/pipe blocksize=8192 > > > > When I'm doing > > > > $ bzcat system01.dbf.bz2 >/tmp/pipe > > > > It's no big deal because I can just dbv before bzip2, just curious. > > > > Cheers, > > > > g > > > > > > > > -----Original Message----- > > Sent: Wednesday, October 03, 2001 1:05 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > mknod exp.pipe p > > # read the pipe - output to zip file in the background > > compress < exp.pipe > scott.exp.Z & > > # feed the pipe > > exp userid=scott/tiger file=exp.pipe ... > > > > > > > > Hi Suhen, > > > > > > I guess the flwng is the syntax: > > > > $ mknod -p /mydir/pipe_file 200m > > $ exp user/passwd file=pipe_file tables=abc & > > > > correct me if I am wrong > > > > > > thanq > > srinvias > > -----Original Message----- > > Sent: Tuesday, October 02, 2001 3:25 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Srinivas, > > > > Try using > > nohup compress /u01/dmps/zvr_dd.dmp & > > > > It should not be a problem to close your Unix session. > > I have not had any problems with the Unix compress utility on Oracle > > Dump files. > > > > You could also compress while you export using names pipes. > > Let me know if you want the syntax. > > > > Regards > > Suhen > > > > > > > > Hi Lists, > > > > Shall I close the unix session after submitting my job (compressing > > the > > dmp file after importing) in the background on solaris. > > > > $ compress /u01/dmps/zvr_dd.dmp & > > > > is this harmful ? (like killing the running jobs) > > > > > > thnx in adv > > srinivas > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Tatireddy, Shrinivas (MED, Keane) > > 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: Suhen Pather > > 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: Tatireddy, Shrinivas (MED, Keane) > > 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: Suhen Pather > > 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: Guy Hammond > > 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). > > > __________________________________________________ > Do You Yahoo!? > Listen to your Yahoo! Mail messages from any phone. > http://phone.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: Gogala, Mladen 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).