Do not upgrade to

If you do run @?/rdbms/admin/catupgrd for an Oracle Home on a, you may later realize some objects are missing (probably related to deferred segment creation).

SQL> delete from t1
2 where id in (
3 select from ca, p
4 where p.no_form like '%02.98'
5 and = ca.prod_id
6 );
delete from t1
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound],
[56480], [], [], [], [], [], [], [], [], [], []

The workaround on metalink is amazing :

  • Do not run catupgrd in against a database that is already at

Well, the only solution is to restore your database ! How painful 🙁

Categorized as 11gR2, dba

By Laurent Schneider

Oracle Certified Master

Leave a comment

Your email address will not be published.