sql>conn inventory_new
SQL> purge recyclebin;
Done
SQL> select * from dba_recyclebin;
OWNER OBJECT_NAME ORIGINAL_NAME OPERATION TYPE TS_NAME CREATETIME DROPTIME DROPSCN PARTITION_NAME CAN_UNDROP CAN_PURGE RELATED BASE_OBJECT PURGE_OBJECT SPACE
------------------------------ ------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------
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> select * from 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>
SQL> PURGE TABLESPACE USERS user INVENTORY_NEW;
Done
SQL> PURGE TABLESPACE USERS user INVENTORY_NEW;
Done
SQL> PURGE TABLESPACE USERS;
Done
SQL> PURGE TABLESPACE USERS;
Done
select * from dba_segments where segment_name like 'BIN%' order by bytes desc
INVENTORY_NEW BIN$LzAeRsceX2TgUAB/AQA67A==$0 TABLE USERS 7 2924739 174063616
INVENTORY_NEW BIN$LxwAdgw2hN3gUAB/AQAa2Q==$0 TABLE USERS 7 985683 174063616
INVENTORY_NEW BIN$Lwfinj0ThffgUAB/AQB4nQ==$0 TABLE USERS 5 3351587 174063616
INVENTORY_NEW BIN$L1haIgLLtbvgUAB/AQAOOQ==$0 TABLE USERS 5 3631299 171966464
INVENTORY_NEW BIN$L9ENAF3g4EXgUAB/AQBqzw==$0 TABLE USERS 4 2076915 168820736
INVENTORY_NEW BIN$L6jRWlQviYLgUAB/AQAR+w==$0 TABLE USERS 4 3329179 167772160
INVENTORY_NEW BIN$L4CVqhXMkNrgUAB/AQBpjQ==$0 TABLE USERS 5 3900611 167772160
INVENTORY_NEW BIN$L5SzdlAV1CrgUAB/AQBmiw==$0 TABLE USERS 4 3239955 167772160
INVENTORY_NEW BIN$L0Q8J6wwepvgUAB/AQBgWQ==$0 TABLE USERS 6 3642843 166723584
INVENTORY_NEW BIN$L2x3yEQQ2hfgUAB/AQBGLw==$0 TABLE USERS 5 1092315 166723584
INVENTORY_NEW BIN$LvPExRGNlOvgUAB/AQAMmw==$0 TABLE USERS 6 3189179 166723584
INVENTORY_NEW BIN$L7zvKR5WOLHgUAB/AQA9FA==$0 TABLE USERS 4 2003187 166723584
INVENTORY_NEW BIN$MK5VQ/aMvZrgUAB/AQA+9Q==$0 TABLE USERS 4 3929971 156237824
INVENTORY_NEW BIN$MNaQ9cUhIC3gUAB/AQAx0A==$0 TABLE USERS 5 4113075 156237824
INVENTORY_NEW BIN$MHH7wSZSL0LgUAB/AQBQEA==$0 TABLE USERS 4 2974971 155189248
INVENTORY_NEW BIN$MDWiMza8Oj3gUAB/AQAuZg==$0 TABLE USERS 6 2572595 152043520
INVENTORY_NEW BIN$MMJzGYPSfyvgUAB/AQB56w==$0 TABLE USERS 5 3744859 152043520
INVENTORY_NEW BIN$MF3d7amjNObgUAB/AQAeeA==$0 TABLE USERS 6 3051619 150994944
INVENTORY_NEW BIN$MJo3cf/n8YngUAB/AQA2OA==$0 TABLE USERS 6 3627499 150994944
INVENTORY_NEW BIN$MCGEYDkLTYzgUAB/AQBqGQ==$0 TABLE USERS 5 2113883 150994944
INVENTORY_NEW BIN$L+Uq5+HCpn7gUAB/AQAf5w==$0 TABLE USERS 5 1538595 150994944
INVENTORY_NEW BIN$MEnAFtGeGeDgUAB/AQBosg==$0 TABLE USERS 5 2757115 149946368
INVENTORY_NEW BIN$MIYZnEyzu8zgUAB/AQAZYA==$0 TABLE USERS 4 3394747 149946368
INVENTORY_NEW BIN$L/lIugn4RR/gUAB/AQA2xA==$0 TABLE USERS 5 1147587 148897792
INVENTORY_NEW BIN$MA1mhbKm0fbgUAB/AQBinQ==$0 TABLE USERS 6 2163499 148897792
INVENTORY_NEW BIN$Lwfinj0PhffgUAB/AQB4nQ==$0 TABLE USERS 5 3351323 95420416
INVENTORY_NEW BIN$L1haIgLHtbvgUAB/AQAOOQ==$0 TABLE USERS 5 1877347 92274688
INVENTORY_NEW BIN$L5SzdlAR1CrgUAB/AQBmiw==$0 TABLE USERS 4 3221299 92274688
INVENTORY_NEW BIN$L9ENAF3c4EXgUAB/AQBqzw==$0 TABLE USERS 4 1265923 92274688
INVENTORY_NEW BIN$L4CVqhXIkNrgUAB/AQBpjQ==$0 TABLE USERS 5 3570435 92274688