oracle purge dba_recyclebin,How to purge recyclebin?

>

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

>

How would you know? You are not querying the recycle bin with those queries; you are querying dba_segments.

If you want to know what is in the recycle bin you have to query the recycle bin.

>

Viewing and Querying Objects in the Recycle Bin

Oracle Database provides two views for obtaining information about objects in the recycle bin:

View Description

USER_RECYCLEBIN This view can be used by users to see their own dropped objects in the recycle bin. It has a synonym RECYCLEBIN, for ease of use.

DBA_RECYCLEBIN This view gives administrators visibility to all dropped objects in the recycle bin

>

Just because an object name begins with BIN$ doesn't mean that object is in the recycle bin. It just means that at one point it was in the recycle bin.

Those objects you displayed are INDEXes.

>

When you restore a table from the recycle bin, dependent objects such as indexes do not get their original names back; they retain their system-generated recycle bin names. You must manually rename dependent objects if you want to restore their original names.

>

See Using Flashback Drop and Managing the Recycle Bin in the DBA Guide

http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm

>

Restoring Dependent Objects

When you restore a table from the recycle bin, dependent objects such as indexes do not get their original names back; they retain their system-generated recycle bin names. You must manually rename dependent objects if you want to restore their original names. If you plan to manually restore original names for dependent objects, ensure that you make note of each dependent object's system-generated recycle bin name before you restore the table.