Is there a way to drop a Tablespace that has no datafile?
I accidently deleted the datafile associated with the
tablespace and I have no back up for it.
I performed the following steps to fix the problem after shutting down
database and mounting it in exclusive mode:
Media recovery is needed after this stepQuote:> alter database create datafile 'raid/oracle/app/abcd.dbf'
Now, it complains that with this error:Quote:> alter database recover datafile 'raid/oracle/app/abcd.dbf'
ORA-00279: Change generated at 5/31/00 12:50pm needed for thread 1
ORA-00289: Suggestion : '/raid/oracle/app/000014244.arc'
ORA-00280: Change 1234567865 for thread 1 is in sequence #86831
After this step, the database doesn't open at all. It complains bad
Is there a simple way to delete the datafile or tablespace when database
is mounted only?