- 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 exists1 2 3 4 5 | ORA-39001: invalid argument valueORA-39000: bad dump file specificationORA-31641: unable to create dump file “/data/app/oracle/dbaclass_estim.dmp“ORA-27038: created file already existsAdditional 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.
As expected, we didnt received the error – ORA-27038: created file already exists.
1 | expdp parfile=exp_reusedmp.par |