Re: Datafile Deleted While Instance Down - HELP!

If you can recreate the indexes (ie you have a script saved somewhere) you can:

startup nomount the DB
alter database mount
alter database datafile 'filename' offline drop; alter database open;
you can try to extract the DDL of indexes or the names with select index_name from user_indexes where tablespace_name = ... when you have everything you need for the rebuilding of indexes drop tablespace including contents
recreate the tablespace and the indexes.

MM

"David A. Ceretti" wrote:

> While my instance was down, a datafile for an index tablespace was deleted.
> Now my instance won't start because it can't find the datafile. What can I
> do? The datafile wasn't backed-up, and I don't care about restoring it.
> The vitals are in the rest of the DB.
Received on Thu Nov 09 2000 - 02:48:17 CST