My Oracle Support Banner

ORA-01537, ORA-00376: When Recreating a Datafile After Offline Drop (Doc ID 100718.1)

Last updated on DECEMBER 11, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


 Problem Description
You have offline dropped a datafile then try to recreate the datafile (ALTER
DATABASE ADD DATAFILE) with the same name and get error message:

 ORA-1537 (datafile already exists) even though you have offline dropped it.

 ORA-01537: "cannot add data file '%s' - file already part of database"
     Cause:  During CREATE or ALTER TABLESPACE, a file being added is already
             part of the database.
    Action:  Use a different file name.

 ORA-00376: "file %s cannot be read at this time"
     Cause:  attempting to read from a file that is not readable. Most likely
             the file is offline.
    Action: Check the state of the file. Bring it online




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.