Data pump export fails with ORA-39000, ORA-31641,ORA-27038

Error Description:
---------------------------------------
Data pump export fails with following error.
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/backup1/d.dmp"
ORA-27038: created file already exists
Additional information: 1

Cause of the problem:
-------------------------------
Within the dumpfile parameter it was given the name as d.dmp. And directory parameter was set to /backup1. In the location of /backup1 there already exists d.dmp. Oracle data pump will generate error if the file name provided with dumpfile already exists in the destination.

Solution of The problem:
------------------------------------
Either rename the OS file name in the specified directory to a new name and perform export.
$mv /backup1/d.dmp /backup1/d2.dmp
Or, drop the existing file from the OS and perform export if OS file no longer necessary.
SQL> !rm /backup1/d.dmp

Or, rename the directory or dumpfile parameter to a new name so that OS file name does not conflict with the dumpfile+directory name.

$expdp dumpfile=d3.dmp

Related Documents:
--------------------------------