Objects in sys.recyclebin$ don't get freed.
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