how to recover dropped table
Posted on 2007-12-02
I am working with Oracle 10gR2 on HP-UX 11. I have accidentally dropped a user table from my database ( a test database) and now i want to recover it. I dont have any EXPORT backup of either the database (full) or just the table. Neither do i have a RMAN backup of the database. I have some naive questions regarding this scenario:
1. Suppose if i am running Oracle 9iR2 and i just have a RMAN backup of the database. I do not have any EXPORT backup. How can i go ahead recovering the dropped table?? Is the Full recover just before the dropping only option of recovering it??
2. If I am using Oracle 10gR2 and i have just a RMAN backup of the database, in this case
2.a Can i recover just the dropped table using this RMAN backup??
2.b There is a option of Flash Recovery Area in Oracle 10gR2. If i set it ON, then i know i can recover the dropped table using flashback logs. If this option is set to OFF, how can i recover the dropped table??
3. Oracle 10gR2 has the RECYCLE BIN option. Any table that has been dropped will be stored in this BIN. Now
3.a For how much time will this data reside in the RECYCLE BIN?? Is there any retention period for this data in the BIN??
3.b Has the RECYCLE BIN got anything to do with the Flash Recovery Area?
Any information will be of a great help.