RE: datapump export to pipe
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "jifjif@xxxxxxxxx" <jifjif@xxxxxxxxx>, "tony.adolph.dba@xxxxxxxxx" <tony.adolph.dba@xxxxxxxxx>
- Date: Tue, 6 Oct 2009 13:03:28 +0200
Not a solution for the pipe, but if all you want to do is to compress the
export, then you can use the compression parameter:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#SUTIL201
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of ~Jeff~
Sent: dinsdag 6 oktober 2009 6:43
To: tony.adolph.dba@xxxxxxxxx
Cc: Oracle Discussion List
Subject: Re: datapump export to pipe
Hi Tony
unfortunately it's not possible, as Oracle no longer treats the file
sequentially. See metalink #276521.1 , 463336.1
This means that using split and exporting direct to tape is also out.
At least expdp is much quicker than exp :]
cheers-
Jeff Wong
On 06/10/2009, Tony Adolph <tony.adolph.dba@xxxxxxxxx> wrote:
> 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
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
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)