Hi,
I purged the Recycle bin, yet DBA_SEGMENTS is showing a lot of BIN$ objects.
Any idea why is that?
Oracle 11g R2 on Windows 2008
SQL> PURGE RECYCLEBIN ;
Recyclebin purged.
SQL>SELECT SEGMENT_NAME, BYTES/1024/1024 MB, SEGMENT_TYPE
FROM DBA_SEGMENTS
WHERE TABLESPACE_NAME='USERS'
ORDER BY BYTES;
SEGMENT_NAME MB SEGMENT_TYPE
------------------------------ ---------- ------------
BIN$PbBrHxfMRQWvpw22LYdAAw==$0 204 TABLE
BIN$T/QfYeIkRCChBlYyv7MGPQ==$0 204 TABLE
BIN$ZYmh2QYeQHazW9jvTZybMw==$0 204 TABLE
BIN$hQC0RGIqSlib5gAjGwtbKA==$0 204 TABLE
BIN$KrQQw7eVRVakGrcaE70g/A==$0 204 TABLE
BIN$n40tnsK+SkSms0j+ZfRu3A==$0 204 TABLE
TMP_LEE_SPOT2 204 TABLE
BIN$H9nv6G49TNKv/v4UBVIBHQ==$0 204 TABLE
BIN$jK21hthETEKTCge90B7YKA==$0 204 TABLE
TEMP_TEST01_SCE 204 TABLE
BIN$LeUANtbPQAiYNLi87n6jJA==$0 205 TABLE