Home » RDBMS Server » Server Administration » Datafile drop problem
Datafile drop problem [message #57216] Wed, 28 May 2003 22:10
vinit
Messages: 7
Registered: October 1999
Junior Member
i have database in noarchive log mode & i added one small data file to data base later on i have removed that datafile after making database in archivelog mode & datafile offline with os commnad. after again i started database but its not allowing me to create any more object in schema and "The following error has occurred:

ORA-00372: file 15 cannot be modified at this time
ORA-01110: data file 15: '/data1/oracle/oradata/eltprod/elt_pcadata05.dbf'
ORA-00372: file 15 cannot be modified at this time
ORA-01110: data file 15: '/data1/oracle/oradata/eltprod/elt_pcadata05.dbf'
"

How i can resolve it ..i don't want that datafile & i don't have any backup too. there is no physical datafile present.
Previous Topic: Multiblock Read Count
Next Topic: Oracle Restore
Goto Forum:
  


Current Time: Fri Sep 20 09:38:25 CDT 2024