sqldatabaseoracle-databaseoracle-sqldeveloperflashback

How Do I recover data from a dropped Table?

I accidentally dropped a table, and I recovered it with flashback statement and recycle bin information:

FLASHBACK TABLE "XXXXXXXXXXXXXXX==$0" TO BEFORE DROP;

But when I made it a select * from XXX it was empty.
Is there a way to recover the rows/information/data from that table?

OR, Does flashback recover all rows? maybe it's empty because it didn't have nothing at the first time.

Solution

  • Have you tried FLASHBACK TABLE "XXXXXXXXXXXXXXX==$0" TO TIMESTAMP Clause? http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmflash.htm#BRADV8702

    FLASHBACK should recover the rows. This is its main purpose.