Home » RDBMS Server » Server Utilities » overwrite existing dump file in expdp in oracle 10g
overwrite existing dump file in expdp in oracle 10g [message #550891] Fri, 13 April 2012 05:33 Go to next message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
Hi All,

How we can overwrite existing dump file for expdp in oracle 10g because everytime we excute expdp and dmp file exist we get below error

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "C:\scott_emp.dmp"
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists

We have one feature in 11g reuse_dumpfiles=y ,which doesnt work in 10g, I want something which can overwrite existing dumpfile in 10g?

Thanks
Re: overwrite existing dump file in expdp in oracle 10g [message #550899 is a reply to message #550891] Fri, 13 April 2012 06:24 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have not.
So include it in your shell script.

Regards
Michel
Previous Topic: Daily Base Back up file
Next Topic: schema not found
Goto Forum:
  


Current Time: Fri Mar 29 03:14:50 CDT 2024