Oracle PL/SQL/SQL Plus/recyclebin

A dropped table is preserved in the recycle bin until purged.

   <source lang="sql">
 

SQL> SQL> SQL> create table myTable (col1 number primary key); Table created. SQL> SQL> drop table myTable; Table dropped. SQL> SQL> select object_name, original_name, type from recyclebin; no rows selected SQL> SQL> purge recyclebin; Recyclebin purged. SQL> SQL> select object_name, original_name, type from recyclebin; no rows selected SQL> SQL> SQL>

 </source>
   
  

purge recyclebin

   <source lang="sql">
 

SQL> SQL> purge recyclebin; Recyclebin purged. SQL> drop table vacation;

SQL> SQL> select object_name, original_name, droptime

 2  from   recyclebin;

no rows selected SQL> SQL> flashback table vacation to before drop;

SQL> SQL>

 </source>