RE: Background jobs inUnix

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Wed, 03 Oct 2001 03:24:53 -0700
Message-ID: <F001.003A0270.20011003031518@fatcity.com>

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: Shrinivas.Tatireddy_at_med.ge.com

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane)   INET: Shrinivas.Tatireddy_at_med.ge.com

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
  INET: guy.hammond_at_avt.co.uk

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 Wed Oct 03 2001 - 05:24:53 CDT