Re: datapump export to pipe
Date: Tue, 6 Oct 2009 16:52:15 -0700 (PDT)
Kind of reminds me when Oracle stopped supporting the creation of datafiles when using symbolic links that already existed... Oh well, whatsya gonna do...?
Robert G. Freeman
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
From: Adric Norris <spikey.mcmarbles_at_gmail.com> To: ORACLE-L <oracle-l_at_freelists.org> Cc: robertgfreeman_at_yahoo.com
Sent: Tue, October 6, 2009 4:41:59 PM
Subject: Re: datapump export to pipe
On Tue, Oct 6, 2009 at 17:04, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
It's in 11gR1. The parameter is REUSE_DUMPFILES ... this will allow you to re-use an existing dumpfile. As I've said before, I've not tested this with the old compression methods (mknod, etc) but I would suspect it works.
That parameter only works for normal files... on 188.8.131.52 under Solaris, anyway. If the existing file is a named pipe you get:
$ expdp system DIRECTORY=dptest DUMPFILE=dptest.pipe TABLES=system.test REUSE_DUMPFILES=y
Export: Release 184.108.40.206.0 - 64bit Production on Tuesday, 06 October, 2009 17:24:31
Copyright (c) 2003, 2007, Oracle. All rights reserved. Password:
Connected to: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable to create dump file "/oracle/admin/CDCSRC/temp/dptest.pipe" ORA-27038: created file already exists
Additional information: 1
ORA-27037: unable to obtain file status
Additional information: 5
While it's true that Oracle didn't technically remove the compression feature (since it was never actually part of the exp/imp utilities), they were most definitely aware that compression through a named pipe was a very common practice. Metalink (now My Oracle Support) has plenty of examples, which strongly implies to me that it was a supported configuration.
-- "I'm too sexy for my code." - Awk Sed Fred. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 06 2009 - 18:52:15 CDT