Re: datapump export to pipe

  • From: "~Jeff~" <jifjif@xxxxxxxxx>
  • To: tony.adolph.dba@xxxxxxxxx
  • Date: Tue, 6 Oct 2009 17:42:49 +1300

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


Other related posts: