- 03 Sep, 2023
- 0 Comments
- 44 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 exists
<br />ORA-39001: invalid argument value<br />ORA-39000: bad dump file specification<br />ORA-31641: unable to create dump file “/data/app/oracle/dbaclass_estim.dmp“<br />ORA-27038: created file already exists<br />Additional information: 1<br />
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=YAt 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.