Re: Datafile Deleted While Instance Down - HELP!

You may also want to make sure there weren't any tables accidently created in that index tablespace before you drop it. If there is one there you may be able to salvage some or all of it.

In article <3A0A64D1.20E3E0D5_at_venis.it>,   Marco Minio <m.minio_at_venis.it> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 09 2000 - 11:19:24 CST