Re: Datafile deleted URGENT

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Mon, 22 Jun 1998 17:24:29 +0200
Message-ID: <6mlt2h$ggk$1@sunrise.pg.gda.pl>

>Question: someone deleted my datafiles on my Oracle Vesion 7.3.3 running
>on SUN Solaris 2.55. Currently the database is complaining of read error
>and cannot insert into tables, as these datafiles were used for index.
>
>I have tried using "alter database datefile ' ' offline drop" and then
>do "recover database until cancel" but it still does not work.
>
>Could someone please help urgently.

Is your database in archivelog or noarchivelog ? If in noarchivelog, you have to restore all database from backup or export.

Regards,
Piotr Received on Mon Jun 22 1998 - 10:24:29 CDT