RE: Background jobs inUnix

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Wed, 03 Oct 2001 06:40:28 -0700
Message-ID: <F001.003A0549.20011003060027@fatcity.com>

I wouldn't have thought so... bzcat will read a file compressed with bzip2 (which I have found gives superior compression and performance to gzip -9), uncompress it and write the uncompressed file out as a stream, rather than uncompressing the file all the way, reading it, then deleting the uncompressed version or recompressing it. (I wouldn't need to export via a pipe to compress, since bzip2 is happy with files >2G anyway). What I was trying to do was verify that hotbackedup (is that a word?) files survived compression OK.

It makes sense for exp to write to a stream, because that's how Unix handles files anyway, but I wonder if dbv reads sequentially or requires random access to the file. That would explain why it wouldn't be happy reading a stream from a pipe...

Hmm,

g  

-----Original Message-----
Sent: Wednesday, October 03, 2001 2:20 PM To: Multiple recipients of list ORACLE-L

can you actually do dbv on a zipped file???

• Guy Hammond <guy.hammond_at_avt.co.uk> 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
  -- 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 - 08:40:28 CDT