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.