We have a Oracle 9i installed consisting of a number of tablespaces. The platform is SUn solaris.Accidentally one of the datafile in a particula tablespace has been removed. There is an export backup of the user who is a default user of the tablespace. the database has been shut down and is not getting up. Can someone suggest answer to the following questions
1) How to start up the database.
2) How to recover the tablespace from the export backup
3) And if 2 is not possible how to drop the tablespace.
Thanks in advance.
1) How to start up the database.
2) How to recover the tablespace from the export backup
3) And if 2 is not possible how to drop the tablespace.
Thanks in advance.