SQL> select * from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME OPERATION TYPE TS_NAME CREATETIME DROPTIME DROPSCN PARTITION_NAME CAN_UNDROP CAN_PURGE RELATED BASE_OBJECT PURGE_OBJECT SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------
BIN$nJ5JuP9cQmqPaArFei384g==$0 TEST DROP TABLE ROME 2007-03-08:10:49:36 2007-03-20:09:38:13 11311453 YES YES 60025 60025 60025 8
BIN$/d2RP/L5SCmBAtczQZvKTA==$0 PK_TEST DROP INDEX ROME 2007-03-09:16:57:22 2007-03-20:09:38:13 11311449 NO YES 60025 60025 60151 8
BIN$QoxoonHNRRSZ/sdsnNK91A==$0 TEST_MY DROP TABLE ROME 2007-03-07:10:42:55 2007-03-19:15:28:27 11243640 YES YES 59940 59940 59940 8
BIN$uWpdwiSPRx6wvUJwAEyQ4A==$0 T2 DROP TABLE ROME 2007-03-15:09:53:33 2007-03-16:15:32:20 10997403 YES YES 60684 60684 60684 8
BIN$M4D+ImL7SlSQVqvweZwspg==$0 SYS_C0010746 DROP INDEX ROME 2007-03-15:09:53:33 2007-03-16:15:32:20 10997401 NO YES 60684 60684 60685 8
BIN$KfazB1b/RI6m1HbT72Jm0w==$0 T1 DROP TABLE ROME 2007-03-09:10:22:31 2007-03-16:15:32:18 10997385 YES YES 60115 60115 60115 8
BIN$1EIvA8GiTvGgeT07o+Buog==$0 SYS_C0010460 DROP INDEX ROME 2007-03-09:10:22:31 2007-03-16:15:32:18 10997381 NO YES 60115 60115 60116 8
7 rows selected
SQL> purge table "BIN$nJ5JuP9cQmqPaArFei384g==$0";
Done
SQL> select * from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME OPERATION TYPE TS_NAME CREATETIME DROPTIME DROPSCN PARTITION_NAME CAN_UNDROP CAN_PURGE RELATED BASE_OBJECT PURGE_OBJECT SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------
BIN$QoxoonHNRRSZ/sdsnNK91A==$0 TEST_MY DROP TABLE ROME 2007-03-07:10:42:55 2007-03-19:15:28:27 11243640 YES YES 59940 59940 59940 8
BIN$uWpdwiSPRx6wvUJwAEyQ4A==$0 T2 DROP TABLE ROME 2007-03-15:09:53:33 2007-03-16:15:32:20 10997403 YES YES 60684 60684 60684 8
BIN$M4D+ImL7SlSQVqvweZwspg==$0 SYS_C0010746 DROP INDEX ROME 2007-03-15:09:53:33 2007-03-16:15:32:20 10997401 NO YES 60684 60684 60685 8
BIN$KfazB1b/RI6m1HbT72Jm0w==$0 T1 DROP TABLE ROME 2007-03-09:10:22:31 2007-03-16:15:32:18 10997385 YES YES 60115 60115 60115 8
BIN$1EIvA8GiTvGgeT07o+Buog==$0 SYS_C0010460 DROP INDEX ROME 2007-03-09:10:22:31 2007-03-16:15:32:18 10997381 NO YES 60115 60115 60116 8
SQL> purge recyclebin;
Done
SQL> select * from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME OPERATION TYPE TS_NAME CREATETIME DROPTIME DROPSCN PARTITION_NAME CAN_UNDROP CAN_PURGE RELATED BASE_OBJECT PURGE_OBJECT SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------
SQL>