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

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log