Recover a dropped table - Oracle Database Script. Flashback TABLE AODBA.EMP TO BEFORE DROP; -- Restore the dropped table with a new name Flashback table AODBA.EMP to before drop rename to EMP_BACKUP; Note - To recover the table, table should be present in recyclebin: select * from dba_recyclebin;
Flashback TABLE AODBA.EMP TO BEFORE DROP; -- Restore the dropped table with a new name Flashback table AODBA.EMP to before drop rename to EMP_BACKUP; Note - To recover the table, table should be present in recyclebin: select * from dba_recyclebin;