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
at

2 comments:

  1. AnonymousTuesday, 15 February, 2011

    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

    ReplyDelete
  2. Byte64Wednesday, 16 February, 2011

    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.

    ReplyDelete

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio