- 03 Sep, 2023
- 0 Comments
- 39 Secs Read
REUSE_DUMPFILES Parameter In EXPDP
REUSE_DUMPFILES Parameter In EXPDP
If we try to export a dumpfile with the name, which is already present in that directory. then we will get error like ORA-27038: created file already existsORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31641: unable to create dump file “/data/app/oracle/dbaclass_estim.dmp“ ORA-27038: created file already exists Additional information: 1
So if the requirement is to overwrite the existing dumpfile, then REUSE_DUMPFILES parameter can be used with EXPDP.
Just you need to mention in PARFILE REUSE_DUMPFILES=Y
At this point, we already have the dumpfile dbaclass_estim.dmp . So the EXPDP job should overwrite this dumpfile.
expdp parfile=exp_reusedmp.parAs expected, we didnt received the error – ORA-27038: created file already exists.