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
Smart way of Technology 