Object Point in Time Recovery

Down Time Required

Yes (If the auxiliary instance is being created same on prod)

No (If the auxiliary instance is being created on test environment)

Data Loss: No

Archive Log Mode: Yes

1. Drop table and insert some records in another table

2. Shut down the database and take backup

3. Restore the database from previous backup where dropped table exists

4. Recover the database just before the time the table is dropped

5. export the table using exp utility

6. Shutdown the database and restore the recent backup

7. Import the table using imp utility

That's it!!!

Regards

Charan