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!

How to clear dba_recyclebin for a particular user

835815Jul 15 2011 — edited Jul 15 2011

Hi,

Can any1 tell me how to clear the objects from dba_recyclebin for a particluar owner as a sysdba . Below the owner objects in dba_recyclebin

SQL> SELECT count(OBJECT_NAME),TYPE from DBA_RECYCLEBIN WHERE OWNER='FRPDWSO' group by TYPE ;

COUNT(OBJECT_NAME) TYPE
------------------ -------------------------
                29 INDEX
                 9 TABLE
               261 Index Partition
                72 Table Partition

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 12 2011

Added on Jul 15 2011

#general-database-discussions

7 comments

7,947 views