| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: parameter to overwrite dump file when using expdp
Forgot to copy the group
-----Original Message-----
From: Powell, Mark D
Sent: Wednesday, January 10, 2007 10:57 AM
To: 'Harvinder.Singh_at_MetraTech.com'
Subject: RE: parameter to overwrite dump file when using expdp
Doesn't exp also refuse to overwrite the existing dump file? I consider this a safety feature.
If a prior export failed then remove the output files before restarting. If you have written a job you want to run daily then generate the export file name so each day you get a different file name or if you insist on reusing the file name then remove the file prior to starting the export as part of the task.
-----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
Is there any way to force overwrite the existing dump file?
Thanks
--Harvinder
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 10 2007 - 09:57:41 CST
 |
 |