This content has been marked as final. Show 4 replies
What, exactly, do you mean when you say " I do not have flash back enabled on the database"? Are you talking about flashback logging? Because that is not relevant here. Are you saying that you disabled the recycle bin?
Unless you proactively disabled the recycle bin, you should be able to
which will recover the table from the recycle bin.
FLASHBACK TABLE table_name TO BEFORE DROP
I meant the recycle bin is not of any use as the table was dropped with a purge option. Hence, FB is of no use here.
That is why, I am going for Rman.
Recover a Dropped or Deleted Table Using RMAN Backup
To recover from a dropped or truncated table, a dummy database (copy of primary) will be restored and recovered to point in time so the table can be exported.
Once the table export is complete, the table can be imported into the primary database. This dummy database can be a subset of the primary database.
please refer below MOS note for more info.
How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN [ID 223543.1]