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=expdirORA-39001: invalid argument valueDump 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.
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
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:
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
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.
Post a Comment