Re: importing a compressed .dmp

From: Philip Chee <philip_at_aleytys.pc.my>
Date: 1997/06/25
Message-ID: <867253761.3122snx@aleytys.pc.my>#1/1

In article <33B0C4FD.664DFF_at_no-spam.pmcgettigan.demon.co.uk> stevep_at_no-spam.pmcgettigan.demon.co.uk writes:
>Andrew Jatras wrote:
 

>> Someone once told me that there is a way to do an import
>> of a .dmp file without first uncompressing the file. If anyone
>> knows of this please post. We are running Oracle 7.3.2 with Solaris
>> 2.5.1.
 

>Hmmm... Don't really see how - because how would Import know which
>compression engine/method you had used? (pkzip, compress, arj, etc.)

I think he meant "without having to create an uncompressed file as an intermediate stage". Useful if you are short of disk space.

The standard trick is to mknod a named pipe, open one session and start gunzipping to the pipe, open another session and import from the pipe. I think it's in one of the Oracle FAQs.

Philip

---=====================================================================---

  Philip Chee: Tasek Cement Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932    Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

---
 þ 10031.28 þ Best file compressor around: DEL *.* (100% compression)

Received on Wed Jun 25 1997 - 00:00:00 CDT