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