RE: Backup and Recovery Question

[Koivu, Lisa]

Sanjay, sounds like alternate server recovery to me.  I have never had to do one myself.  Recover the database to another server to the time prior to the drop, export the table from this database, and import it into your original database.  I'm sorry I can't give exact specifics on how to do this but I do know it is possible.   Lisa -----Original Message----- From: Sanjay Kumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 12:16 PM To: Multiple recipients of list ORACLE-L Subject: Backup and Recovery Question Hi,   I have a situation like this.   I found a user dropping a table today at 9 AM but I came to know about that only at 2 PM the same day. I have a backup which was taken the previous day at 4 PM. My database runs in Archivelog mode.   I want to restore the table. If I put the database in recovery mode and recover using until time option then I may loose all the transactions that happened between 9 to 2. But I dont want to loose that.   I donot have a export.   How do I accomplish this?   Help Appreciated.   Vinay