Thursday, March 06, 2008

ORA-31641: unable to create dump file

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

You are getting this error while performing a data pump export (EXPDP) using a dump filename that is already present at the destination.

EXPDP 'user/pwd' SCHEMAS=user DUMPFILE=dumpfile.dmp NOLOGFILE=Y DIRECTORY=expdir
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "C:\oracle\product\10.1.0\admin\orcl10\dpdump\dumpfile.dmp"
ORA-27038: created file already exists
OSD-04010: option specified, file already exists
Dump files are never overwritten (in contrast with LOG files and SQL files generated by the data pump), so you must either change the dump filename in the command line or rename or move or delete the existing file prior to attempting the operation again.

See a previous posting for other common error situations that you can encounter when performing a data pump export.

See message translations for ORA-31641 and search additional resources

2 comments:

Anonymous said...

Hello and thanks for your article..
Is there away of keeping the dump file and creating a new one every time i run the export job based on a script that changes and creates a dump file automatically?

thanks
ammar83_h@yahoo.com

Byte64 said...

Yes, if you are using some script to do this you can assemble the dump file name including the timestamp. On Windows this is somewhat tricky but i remember I did it once and it worked. On Unix should be much easier and there should be plenty of example in the web.

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles