Re: Export to stdout

> on disk enough for dmp file. Is there any way to export to standar > output to filter it with a compressor utility like gzip.

Not to stdout -- you have to set up a named pipe, specify the pipe as the output (FILE=<pipe>) & set up gzip to take its inpout from the pipe. I use the following script (which must be edited if you want to use it):

#!/bin/ksh

DMPFILE=/home/foo.dmp.gz

#

EXPPARFILE=/home/export_foo.par

#

####################################################################

#

# set up the pipe using the process id of this process for uniqueness

#

NPIPE=/tmp/exppipe.$$

#

# time stamp the log

echo "${0}"

echo "Process start time: `date`"

#

# pipe *must* be re-created new each time

#

/bin/rm ${NPIPE}

#

# Create pipe

#

echo "Export directly to a named pipe"

echo "Setting up pipe named $NPIPE"

/etc/mknod ${NPIPE} p

#

# compress as a background process

#

echo "Compress thru pipe to ${DMPFILE} as a background process"

gzip -c <${NPIPE} >${DMPFILE} &

#

echo "Export using parfile: ${EXPPARFILE}"

exp parfile=${EXPPARFILE} file=${NPIPE}

#

/bin/rm ${NPIPE}

#

echo "Process end time: `date`"

exit Received on Fri Feb 01 2002 - 12:46:18 CST