DBA Hub

📋Steps in this guide1/1

Recover a dropped table

Restore the dropped table with same name:

oracle configurationintermediate
by OracleDba
12 views
1

Recover a dropped table

Restore the dropped table with same name: Restore the dropped table with a new name

Code/Command (click line numbers to comment):

1
2
3
4
SQL>flashback table DBACLASS.EMP to before drop;
SQL>Flashback table DBACLASS.EMP to before drop rename to EMP_BACKUP;
Note - To recover the table, table should be present in recyclebin:
select * from dba_recyclebin;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!