I dropped a table yesterday and I want to restore it. I know that it's done with flashback but the table is not present in the recycle bin (yes it is set as ON).

So how can I restore a table that is not in the recycle bin. I am logged in as sysdba and also there are no rows neither in the dba_recyclebin nor in the user_recyclebin.

  • 1
    Restore from your backup
    – user1822
    Jan 4, 2017 at 9:09

1 Answer 1


You can clone your production database to a point in time before the table was dropped, then export the table you need and import into your prod database. You can also try a table space point in time recovery. I tested it out a few years back, but I haven't needed to do it since.

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.