Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recycle Bin purged but DBA_SEGMENTS has too many BIN$ objects

user12078118Feb 18 2014 — edited Feb 18 2014

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

This post has been answered by Baris Yildirim on Feb 18 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2014
Added on Feb 18 2014
7 comments
2,217 views