Re: importing a compressed .dmp

On Unix you can use a named pipe. Here are the basics:

  mknod named_pipe -p
  nohup uncompress < oracle.dmp.Z > named_pipe &   nohup imp file = named_pipe ... &

The advantage of doing this is if you do not have enough diskspace to uncompress the dmp file. You don't have to use alternate media like tape.

To export do the reverse:

  mknod named_pipe -p
  nohup exp file=named_pipe ... &
  nohup compress < named_pipe > oracle.dmp.Z &

In article <33B0C4FD.664DFF_at_no-spam.pmcgettigan.demon.co.uk>, stevep_at_no-spam.pmcgettigan.demon.co.uk says...
>
>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 don't think you'd gain any advantage over decompressing it first and
>then importing it to be honest. If you wanted to automate such a system
>(as we do) then use a shell script.
>
>Steve Phelan.
>
>
Received on Thu Jun 26 1997 - 00:00:00 CDT