You can open the database as sysdba. You can recover the objects from
the data dictionary via a variety of means. Drop the tablespace,
including contents (after you do this the objects will be removed
fromthe data dictionary so don't do this until you've recovered the
objects --- using in the form of scripts). Delete the datafile via
the OS. Create a new tablespace with the same name. Run the scripts.
You won't save any data but you should be able to recreate the
schema.
Then shutdown the instance and make a cold backup.
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 20 2005 - 20:25:23 CST
