Overwrite existing dumpfile during EXPDP backup

Overwrite dumpfile with reuse_dumpfiles parameter in EXPDP

C:\WINDOWS\system32>expdp hr@pdb1 directory=dbbackup dumpfile=hr.dmp logfile=hr.log

Export: Release 18.0.0.0.0 - Production on Sun Jan 23 10:39:17 2022
Version 18.4.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
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:/backup\hr.dmp"
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists

Solution: Use the reuse_dumpfiles=y in EXPDP command

C:\WINDOWS\system32>expdp hr@pdb1 directory=dbbackup dumpfile=hr.dmp logfile=hr.log  reuse_dumpfiles=y

Export: Release 18.0.0.0.0 - Production on Sun Jan 23 12:20:42 2022
Version 18.4.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Password:

Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Starting "HR"."SYS_EXPORT_SCHEMA_01":  hr/********@pdb1 directory=dbbackup dumpfile=hr.dmp logfile=hr.log reuse_dumpfiles=y
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.