REUSE_DUMPFILES Parameter In EXPDP

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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.par
As expected, we didnt received the error – ORA-27038: created file already exists.