Re: [Q]: Dynamically compressing the .dmp file while exporting ?

Here is a neat set of commands to test for Unix:

  mknod pnod p
  nohup compress <pnod >bk.Z &
  nohup ls -lart > pnod &
  rm pnod

What these commands do:
1) Creates a named pipe to funnel data through 2) Places a "compress" command in background to compress all that comes through the pipe
3) Issues an "ls" command to supply the pipe with data. This could be replaced with an export command 4) Remove the named pipe

To export a database with export file compression on the fly:

  mknod pnod p
  nohup compress <pnod >bk.Z &
  nohup exp un/pwd [parameters] > pnod &   rm pnod

This would produce a compressed export file named bk.Z. The reverse can be done to uncompres bk.Z and pipe it to an import.

This helps if you are in the situation where you do not have enough disk space to create the export file because the named pipe file does not grow to be a very large size.

This does work. I have done this before. Received on Fri Apr 12 1996 - 00:00:00 CEST