Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Datafile deleted URGENT

Datafile deleted URGENT

From: ecbdu <ecbdu_at_pacific.net.sg>
Date: Mon, 22 Jun 1998 18:58:22 -0500
Message-ID: <358EEF9E.1588@pacific.net.sg>


Hi there,

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.

Regards. Received on Mon Jun 22 1998 - 18:58:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US