How to fix the Oracle error ORA-38772: cannot add datafile ‘string’ – file could not be created?

In this post, you’ll learn more about the Oracle ErrorORA-38772: cannot add datafile ‘string’ – file could not be created with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38772: cannot add datafile ‘string’ – file could not be created

Reason for the Error ORA-38772: cannot add datafile ‘string’ – file could not be created

The recovery step of FLASHBACK DATABASE encountered the creation of a datafile and could not recreate the file. The error from the creation attempt is displayed in another message. The control file file entry for the file is ‘UNNAMEDnnnnn’.

How to fix the Error ORA-38772: cannot add datafile ‘string’ – file could not be created ?

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

Use the ALTER DATABASE CREATE DATAFILE statement to create the file.