Re: datapump export to pipe

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 6 Oct 2009 16:52:15 -0700 (PDT)
Message-ID: <688827.19521.qm_at_web38902.mail.mud.yahoo.com>

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
Oracle ACE
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
Blog: http://robertgfreeman.blogspot.com

---

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 11.1.0.7 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 11.1.0.7.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 11.1.0.7.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-l

Received on Tue Oct 06 2009 - 18:52:15 CDT