Flashback Table Drop

SQL> drop table TESTTABLE; Table dropped.
 * Flashback Drop reverses the effect of a DROP TABLE operation.
 * When a table is dropped, it will be renamed, and placed in the Recycle Bin.
 * The Recycle Bin utilizes tablespace where table is on.
 * The Recycle Bin objects are counted against a user’s quota.
 * Oracle will automatically claim the Recycle Bin space if there is storage constraint.
 * Dropped table is renamed and placed in the Recyclebin.

SQL> select * from tab; TNAME                         TABTYPE  CLUSTERID -- --- -- BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE

SQL> show recyclebin
 * To view the contents in the Recyclebin.

ORIGINAL NAME   RECYCLEBIN NAME                OBJECT TYPE  DROP TIME -- -- TESTTABLE        BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE        2004-02-16:21:13:31 SQL> FLASHBACK TABLE TESTTABLE TO BEFORE DROP; FLASHBACK COMPLETE. SQL> FLASHBACK TABLE TESTTABLE TO BEFORE DROP RENAME TO TESTTABLE1; FLASHBACK COMPLETE.
 * Restore the table using Flashback table. The table with the original name will be restored.
 * Optionally, if name change is needed, for example, there is an existing table name already, the option RENAME TO  can be used.

SQL> SELECT * FROM TAB; TNAME                         TABTYPE  CLUSTERID -- --- -- TESTTABLE                     TABLE SQL> PURGE RECYCLEBIN; SQL> DROP TABLE TESTTABLE PURGE;
 * To free up Recyclebin
 * To permanently drop table