Re: TABLE recovery

Actually, even if the database was in ARCHIVELOG mode, sanjay (forgive me if it is not your name) wouldn't be able to recover just the table. In this particular situation, he/she has two choices: 1. Recreate the table and manually enter in all the info. 2. Recover the entire database back to some point in time prior to this user error, using his/her last valid cold backup.

Regards,
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

In article <367E9E8F.A0CEA270_at_nt.com>,
  kapil.parkhi.kparkhi_at_nt.com wrote:
> 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
>

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