Oracle Database Discussions

Hi All,

I selected segments in our Tablespace as :

SQL> select segment_name,segment_type from dba_segments where tablespace_name='M
DMTS_02';

SEGMENT_NAME                   SEGMENT_TYPE
------------------------------ ------------------
D1_MSRMT_BAK                   TABLE
D1_MSRMT                       TABLE
BIN$ljNJJajlQrmlKzwWb7OcYA==$0 INDEX
BIN$c+5EGn8gTlelgM1FfaHDRw==$0 INDEX
BIN$CqgNXgIRT/uQGVMbnSa+kQ==$0 INDEX

Then
SQL> PURGE DBA_RECYCLEBIN;

DBA Recyclebin purged.

But the recyclebin is not cleared :(

SQL> select segment_name,segment_type from dba_segments where tablespace_name='MDMTS_02';

SEGMENT_NAME                   SEGMENT_TYPE
------------------------------ ------------------
D1_MSRMT_BAK                   TABLE
D1_MSRMT                       TABLE
BIN$ljNJJajlQrmlKzwWb7OcYA==$0 INDEX
BIN$c+5EGn8gTlelgM1FfaHDRw==$0 INDEX
BIN$CqgNXgIRT/uQGVMbnSa+kQ==$0 INDEX

Please help...


Thanks,
Kinz