Re: TABLE recovery

Hi

If the database is in NOARCHIVELOG mode then you cannot recover this dropped table. The only way to recover the table is if you have a export of the table then you can reimport it.

Kapil Parkhi

sanjay.raj_at_roche.com wrote:
>
> 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 - 13:16:31 CST