Oracle PL/SQL/SQL Plus/recyclebin

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

  
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>

purge recyclebin

  
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>