Re: Import and Export With Compressed Files

"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