Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import and Export With Compressed Files

Re: Import and Export With Compressed Files

From: michael ngong <mngong_at_yahoo.com>
Date: 13 Sep 2002 07:09:11 -0700
Message-ID: <ecf365d5.0209130609.5ec9c90b@posting.google.com>

"Wells" <wshammou-NoSpam_at_optonline.net> wrote in message news:<Nxag9.8418$e44.550188_at_news4.srv.hcvlny.cv.net>...
> Hi all,
>
> What would be the best way to import or export directly from or into a
> compressed file format.
> Oracle 8.1.7.4, Sun Solaris.
>
> Thanks very much,
> Wells...

To do so you may have to work with pipes Create a pipe
Compress it to a dump file and start exports

creation of Pipe
 mknod exp_pipe p

To compress the exports in the background run the following command
compress<exp_pipe.dmp>export_dmp.Z&

Compress will actually be running in the background(&) wating for data to get to the pipe so it can compress it. You can now go ahead and run your exports exp file=exp_pipe parfile="your parameter file"

Do the same thing for the imports.

There is also a possibility of exporting and importing at the same time but interestingly here, you have to start the import process first before the export process

Create a pipe similar to the one created above mknod mypipe p
First
imp file=mypipe& parfile="your parameter file"; then exp file=mypipe parfile="your export parameter file"

HTH
Michael Tubuo Ngong Received on Fri Sep 13 2002 - 09:09:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US