7 Replies Latest reply: Feb 18, 2014 9:53 PM by Baris Yildirim RSS

    Recycle Bin purged but DBA_SEGMENTS has too many BIN$ objects

    user12078118

      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