Re: On the fly import decompress problem

What about if you created 2 pipes...

cat bigfile | firstpipe | gunzip | secondpipe | import ...

This is just a thought
..

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:A43AA78C3F9DD511AAB100805FBE740D3D5A0F_at_lnewton.leeds.lfs.co.uk...
> So after a fortnight in Mauritius, I get back to work and this happens :
>
> Operating System : HP UX 11:00 32 bit
> Oracle version : 8.0.6.1.1
>
> I was requested to defrag the free space on a very large tablespace (but
> all files < 2 Gb)
>
> I exported via a pipe which compresses on the fly to a disc file. The
> gzipped output file is 5 gig in size and it lives in a file system which
> has large file support enabled. No errors reported by exp or by gzip.
> Data was then dropped from the user involved.
> Tablespace was then defragged (over 250,000 fragments in dba_free_space
> !) - we built this from a cold backup of a customer database - they
> don't have a DBA :o(
> I then tried to re-import via the gunzip process, but gunzip doesn't
> want to know - gives me an unknown error.
>
> This leaves me in a bit of a mess. I know it isn't an Oracle problem,
> but maybe some of you have a work around.
>
> How can I get my data back out of the gzip file ?
> I'm going to try an FTP to my windows PC and try to use WinZip but I
> suspect it will overwhelm my 400 Mhz processor and memory etc.
>
> Cheers,
> Norman.
>
> PS. I now think I need another holiday!
>
> ------------------------------------------------------------------------
> --------
> Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
> ------------------------------------------------------------------------
> --------
>
Received on Fri Sep 14 2001 - 11:07:18 CDT