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 -> TABLE recovery

TABLE recovery

From: <sanjay.raj_at_roche.com>
Date: Mon, 21 Dec 1998 18:15:07 GMT
Message-ID: <75m37a$g6j$1@nnrp1.dejanews.com>


Hi, Holidays are round the corner and I have many problems. One of these problems ----> Some user on one of the databases dropped a table ( Say Table A). Table A was on tablespace B which had only one datafile C. I have a operating system backup of the datafile C. No exports are available. There are 10 tables ( excluding table A) which are there on tablespace B and also associated with the same datafile C. The database was on NT without ARCHIEVELOG. Any idea what is the best ( FASTEST) way to recover table A.

Thanks in advance.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 21 1998 - 12:15:07 CST

Original text of this message

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