> 
> Hello Ari 
>     I am writing to you for the first time. I am working as a DBA with Oracle
> 8.0.4. in archivelog mode.  I have a particular problem. One of my users
> deleted a few thousand rows about three days back. How do I recover the same. 
> 
> Waiting for your quick reply
> 
> Raj Kumar Varma
> 
------ Reply -----
Raj,

It depends on how you have been backing up your database. IF you are using
EXPORT, then you can import just that one table with the deleted rows. Be
sure to check if there are any other tables with depenent data. If so, import
those tables or risk having inconsistent data.

If you did not use EXPORT, then you will have a tougher time. If it is ok to
recover the entire database to three days ago, then simply recover the database
since the last complete backup and apply archived redo logs until three days
ago.

If you must keep all other database data except the one table and do not have
an EXPORT, then you must recover the database onto a second server from three
days back. Then, take an export of the table, ftp the export to the original
server, and import the table. Again, be sure that there are no other related
tables or you must import those tables as well.

If you have more specific questions on the steps to take, I recommend getting
the "Oracle Backup and Recovery" which has step-by-step instructions on how
to recover databases. It's by Oracle Press.

Best of luck,


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 230+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page .htm">Back to Ari Kaplan's Home Page