This discussion is archived
5 Replies Latest reply: Apr 25, 2013 6:23 AM by Srini Chavali-Oracle Branched to a new discussion. RSS

dba_recyclebin vs sys.recyclebin$

IGorbatovsky Newbie
Currently Being Moderated
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
  • 1. Re: dba_recyclebin vs sys.recyclebin$
    rp0428 Guru
    Currently Being Moderated
    >
    Does anybody know the difference between these tables/views - dba_recyclebin and sys.recyclebin$?
    >
    The view 'dba_recyclebin' is based on the table 'sys.recyclebin$'.

    ----additional questions

    What is your 4 digit Oracle version? Check MOS for the bug that was reported on that issue.

    I can reproduce the issue on vanilla 11.2.0.1.0 if I create a table that used an object column with STORE AS nested table storage.

    Dropping the table without a purge will then leave the nested table objects in the recyclebin after a purge.

    Edited by: rp0428 on Apr 21, 2013 10:48 PM
  • 2. Re: dba_recyclebin vs sys.recyclebin$
    Girish Sharma Guru
    Currently Being Moderated
    Probably below thread may be of your interest :

    Re: purge dba_recyclebin - ORA-600 - [ktcdso-1 ]... to upgrade or not?

    OR

    Try to Open the thread in the same forum :
    Database - Upgrade

    Regards
    Girish Sharma
  • 3. Re: dba_recyclebin vs sys.recyclebin$
    IGorbatovsky Newbie
    Currently Being Moderated
    It is 10.2.0.4 (Enterprise Edition)
    The strange thing is that some objects' names in ORIGINAL_NAME column are original names, not system generated ones as 'BIN$%'.
    Like this :

    SERV_HISTORIES
    SERV_HISTORIES
    SERV_HISTORIES
    SERV_HISTORIES
    SERV_HISTORIES
    AI_SERV_HISTORIES_T
    BIN$jWqDBHXNDaTgRAAaSwgMdQ==$0
    BIN$jWqDBHXNDaTgRAAaSwgMdQ==$0
    BIN$jWqDBHXNDaTgRAAaSwgMdQ==$0
    BIN$jWqDBHXNDaTgRAAaSwgMdQ==$0
    BIN$jWqDBHXNDaTgRAAaSwgMdQ==$0
    BIN$jWqDBHXODaTgRAAaSwgMdQ==$0
    SERV_HISTORIES
    SERV_HISTORIES
    BIN$jWqDBHXPDaTgRAAaSwgMdQ==$0
    SRHS_SUBS_DATE_IDX
    SRHS_SUBS_DATE_IDX
    SRHS_SUBS_DATE_IDX
    SRHS_SUBS_DATE_IDX
    SRHS_SUBS_DATE_IDX
    SRHS_SUBS_DATE_IDX
    SERV_HIST_ST_DATE
    SERV_HIST_ST_DATE
    SERV_HIST_ST_DATE
    SERV_HIST_ST_DATE
    SERV_HIST_ST_DATE
    SERV_HIST_ST_DATE
    SRHS_SUBSDATESRLSSRST_IDX
    SRHS_SUBSDATESRLSSRST_IDX
    SRHS_SUBSDATESRLSSRST_IDX
    SRHS_SUBSDATESRLSSRST_IDX
    SRHS_SUBSDATESRLSSRST_IDX
    SRHS_SUBSDATESRLSSRST_IDX
    SRHS_PK


    As per recommendations of ID433768.1 (Invalid Object BIN$xxx In DBA_OBJECTS But Nothing Exists in RECYCLEBIN)
    I though I could purge objects with

    sql> PURGE TABLE "BIN$MYgX9M26WlfgQEWYcNBBlg==$0" ;

    but how could I do it with original names?
  • 4. Re: dba_recyclebin vs sys.recyclebin$
    IGorbatovsky Newbie
    Currently Being Moderated
    Hi,
    I didn't manage to solve the issue, but decided to perform upgrade, which went smoothly. There were no any errors relating to recyclebin objects.

    Still wondering about such behavior.

    Regards,
    Igor
  • 5. Re: dba_recyclebin vs sys.recyclebin$
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Have you opened an SR with Support, as indicated in your other thread - Objects in sys.recyclebin$ don't get freed. ?

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points