Re: FW: parameter to overwrite dump file when using expdp

At version 9.2 on windows, export does not do any checks. It just grab the name from the parameter files, open it for output and writes, even if this a file he created 2 minutes ago as part of the same export.
 From metalink (from memory): Export does not check if the same file is specified twice is in the parameter list.

We never remove files before export, and the export just overwrite the old files.

Adar Yechiel
Rechovot, Israel

oracle-l-bounce_at_freelists.org wrote:
> Forgot to copy the group
>
>
> -- Mark D Powell --
> Phone (313) 592-5148
>
>
> -----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.
>
>
> -- Mark D Powell --
> Phone (313) 592-5148
>
>
> -----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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

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