Re: Q: Exporting large databases,tables (> 2gig)

Here's the technique that we use

o create a named pipe

     mknod export.pipe.dmp p

o start a compression server as a background process

     cat export.pipe.dmp | compress > export.dmp.Z &

o Start the export with output going to the pipe

     exp <user>/<pass> file=export.pipe.dmp

This essentially lets the export output its stuff to the pipe with the pipe's output
going to the compress utility ( whose output could go to a tape with additional commands )

HTH
Jim Gregory

>==========janet, 11/19/96==========
>
>Mike, I'd be real interested in knowing how to do that.
>I've got somebody here who insists that it can be done.
>I maintain that it can't; i've tried several methods;
>he can't actually do it; he just says it can be done.
>We are in Unix.
>thanks!
>janet
>
>
>Mike Streeton wrote:
>>
>> A quick suggestion, does it still fail if you export to a pipe and
>> dd/compress the output from it?
>>
>> Hope this helps
>>
>> Mike

Opinions expressed are mine and do not reflect those of my company or clients. Received on Wed Nov 20 1996 - 00:00:00 CET