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!

dba_recyclebin vs sys.recyclebin$

IGorbatovskyApr 22 2013 — edited Apr 25 2013
Good day,

Does anybody know the difference between these tables/views - dba_recyclebin and sys.recyclebin$? The reason I ask is that I have objects in the second one, while no objects in the first one. The reason I take care is that I have to have sys.recyclebin$ clean, as pre upgrade script utlu112i.sql reports.

WARNING: --> Your recycle bin contains 50 object(s).
.... It is REQUIRED that the recycle bin is empty prior to upgrading
.... your database. The command:
PURGE DBA_RECYCLEBIN
.... must be executed immediately prior to executing your upgrade.

The command it suggests does empty dba_recyclebin, but I still have objects in sys.recyclebin$, that's why I get this warning.

Is there any way of clearing sys.recyclebin$?

Thanks in advance for you advices!

Regards,
Igor
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2013
Added on Apr 22 2013
5 comments
2,992 views