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.
|
|
|