ORA-27038: created file already exists in EXPDP datapump

ORA-27038: created file already exists in EXPDP datapump

Error
ORA-31641: unable to create dump file “C:\employee.dmp”
ORA-27038: created file already exists

C:\windows\system32>expdp directory=dbbackup dumpfile=employee.dmp logfile=employee.log
Export: Release 18.0.0.0.0 - Production on Mon Apr 13 09:33:27 2020
Version 18.4.0.0.0

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

Username: hr@xepdb1
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:\employee.dmp"
ORA-27038: created file already exists
OSD-04010: option specified, file already exists

Solution

REUSE_DUMPFILES parameter is used to prevent this error if you are creating the dump file by replacing the existing dump otherwise you have to rename it manually or by script.

REUSE_DUMPFILES={Y | N}
Y: Existing dumpfiles will be overwritten.
N: Reture Error if same file name already exists in location.


expdp directory=dbbackup dumpfile=employee.dmp logfile=employee.log reuse_dumpfiles=Y

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 )

Google photo

You are commenting using your Google 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.