1 Reply Latest reply on Apr 22, 2013 1:44 PM by Srini Chavali-Oracle

    Objects in sys.recyclebin$ don't get freed.

    IGorbatovsky
      Good day,

      I'm on 10.2.0.4 EE trying to upgrade to 11.2.0.3

      As per preupgrade script (utlu112i.sql) result I have to purge my recyclebin. dba_recyclebin purged successfully, but once i rerun the scripts it told me that I still had objects in my recyclebin

      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.

      It turned out that it took data from sys.recyclebin$.
      Now I need to purge them, but the command, that script suggests doesn't work.
      Not sure about what will happen during upgrade.

      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

      How can I properly clear these objects?
      Thanks in advance for you advices!

      Regards,
      Igor