How to fix the Oracle error ORA-38773: cannot add data file ‘string’ – file already part of database?

In this post, you’ll learn more about the Oracle ErrorORA-38773: cannot add data file ‘string’ – file already part of database with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38773: cannot add data file ‘string’ – file already part of database

Reason for the Error ORA-38773: cannot add data file ‘string’ – file already part of database

The recovery step of FLASHBACK database encountered the creation of a datafile and could not create the file because the file name is already in use in the database. The control file file entry for the file is ‘UNNAMEDnnnnn’.

How to fix the Error ORA-38773: cannot add data file ‘string’ – file already part of database ?

You can fix this error in Oracle by following the below steps

Use the ALTER DATABASE CREATE DATAFILE statement to create the file with a different name.