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 - 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

One comment

  1. Jefferson · · Reply

    No oracle 11G podemos usar o parametro: reuse_dumpfiles=y (padrão é N) que fará sobrepor um antigo export datadump.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: