How To Drop A Table Permanently From Oracle Database?

Dropping table permanently:

SQL> drop table test_tab purge;
Table dropped.

SQL> select OBJECT_NAME, ORIGINAL_NAME, DROPTIME from
recyclebin;
no rows selected.

Purging of table from recycelbin:

SQL> drop table test_tab;
Table dropped.

SQL> select OBJECT_NAME, ORIGINAL_NAME,
DROPTIME from recyclebin;
OBJECT_NAME           ORIGINAL_NAME           DROPTIME
—————————— —————-     ——
BIN$dD1ZsEvnDTHgRAADujKrxQ==$0 TEST_TAB 2010-09-23:12:40:58
SQL> purge table “BIN$dD1ZsEvoDTHgRAADujKrxQ==$0” ;
Table purged.

Purging all the objects from recycelbin:

SQL> select OBJECT_NAME, ORIGINAL_NAME,
DROPTIME from recyclebin;
OBJECT_NAME              ORIGINAL_NAME  DROPTIME
—————————— —————- ——-
BIN$dD1ZsEvnDTHgRAADujKrxQ==$0 TEST_TAB 2010-09-23:12:40:58

SQL>  purge recyclebin;
Recyclebin purged.

SQL> select * from recyclebin;
no rows selected

Research and Article Contribution by : Anju