RE: parameter to overwrite dump file when using expdp

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 10 Jan 2007 15:49:46 -0000
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663BAC0@ENYC11P32005.corpny.csfb.com>

No, there isn't.

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Harvinder Singh Sent: Wednesday, January 10, 2007 10:40 AM To: oracle-l
Subject: parameter to overwrite dump file when using expdp

Hi,

When running expdp if the dumpfile already exists we get the following error:

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/space/backup/hs.dmp"
ORA-27038: created file already exists

Additional information: 1

Is there any way to force overwrite the existing dump file?

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 10 2007 - 09:49:46 CST