A dropped table is preserved in the recycle bin until purged. : recyclebin « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. recyclebin

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>