ORA-31641: unable to create dump file Expdp error
During the EXPDP backup we are getting the following error on executing the command
Error
C:Usersoracle>expdp full=y directory=dbdump
Export: Release 18.0.0.0.0 - Production on Tue Sep 24 12:15:50 2019
Version 18.4.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Username: sys@pdb2 as sysdba
Password:
Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "C:testexpdat.dmp"
ORA-27038: created file already exists
OSD-04010: option specified, file already exists
Cause
Same name file is already present on the directory location.
Solution
We can solve this with two ways:
1. Use REUSE_DUMPFILES parameter in expdp command with “Y” value. default value is “N”(Not to replace old files already present in location)
Expdp usr1/usr1 directory=dbdump dumpfile=expdat.dmp full=y reuse_dumpfiles=y
2. You can rename the old file present manually with OS commands and start the job again.
mv expdat.dmp expdat.dmp_bkp