ALL_TABLES and RECYCLEBIN
SQL> show recyclebin
SQL> show user
USER is "TABLIS"
SQL> create table testtest (test1 number(1));
Table created.
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
TESTTEST
SQL> drop table testtest;
Table dropped.
SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ ----------
TESTTEST BIN$t2kXXZKoQNmDSOz3Ug+zEw==$0 TABLE 2013-06-21
SQL> select table_name from user_tables;
no rows selected
Thanking you in advance