datapump export to pipe
- From: Tony Adolph <tony.adolph.dba@xxxxxxxxx>
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Oct 2009 13:53:42 +1300
Hi all,
Env: Oracle EE 10.2.0.4 RH 4.6
I'm doing exports to a filesystem with limited space so want to compress the
export on the fly, e.g.
.
.
cd $BACKUP_DIR
if [ ! -p $PIPE ] ; then
mkfifo $PIPE
fi
echo "gzipping from $PIPE ..."
nohup gzip -c < $PIPE > ${DMPFILE}.gz &
echo "expdp started ..."
expdp $CREDENTIALS \
DIRECTORY=DP_EXP_DIR \
DUMPFILE=$PIPE \
FULL=y \
LOGFILE=$LOGFILE
.
.
BUT,.. as you may have guessed, my plan is flawed as expdp doesn't allow
writing to a file that already exists, and of course the pipe must (exist
that is)
Does anyone have a work around for this (that doesn't involve upgrading to
11g, buying new disks, exporting to a different dir)
Thanks in advance
Tony
Other related posts:
- » datapump export to pipe - Tony Adolph
- » Re: datapump export to pipe- ~Jeff~
- » RE: datapump export to pipe- D'Hooge Freek
- » RE: datapump export to pipe- Riku Räsänen
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Guillermo Alan Bort
- » Re: datapump export to pipe- Christoph
- » RE: datapump export to pipe- Powell, Mark D
- » RE: datapump export to pipe- Adams, Matthew (GE Indust, ConsInd)
- » RE: datapump export to pipe- Jost,
- » Re: datapump export to pipe- Jared Still
- » RE: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Powell, Mark D
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- MacGregor, Ian A.
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Joey D'Antoni
- » Re: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Tony Adolph
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Adric Norris
- » Re: datapump export to pipe- Robert Freeman
- » Re: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe- Rich Jesse
- » RE: datapump export to pipe- Dunbar, Norman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)
- » RE: datapump export to pipe- Rich Jesse
- » Re: datapump export to pipe- Robert Freeman
- » RE: datapump export to pipe- Mercadante, Thomas F (LABOR)