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!

9.2.0.8 -> 11.2.0.4, face ORA-00600[check_partnum:kkpodInitIntFieldsAfterLoad]

user536563Dec 25 2014 — edited Dec 26 2014

hi,

when I run catupgrd.sql, I have ora600[check_partnum:kkpodInitIntFieldsAfterLoad] when the script execute

how to fix?  >"<

SQL> -- we also need to update the statistic
SQL> begin
  2 dbms_stats.delete_table_stats('SYS', 'OBJ$MIG');
  3 dbms_stats.delete_table_stats('SYS', 'USER$MIG');
  4 dbms_Stats.gather_table_stats('SYS', 'OBJ$MIG', estimate_percent => 100,
  5 method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');
  6 dbms_Stats.gather_table_stats('SYS', 'USER$MIG', estimate_percent => 100,
  7 method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY');
  8 end;
  9 /
begin
*
ERROR at line 1:
ORA-00600: internal error code, arguments:
[check_partnum:kkpodInitIntFieldsAfterLoad], [2147483681], [3], [], [], [], [],
[], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 24232
ORA-06512: at "SYS.DBMS_STATS", line 24332
ORA-06512: at line 4

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2023
Added on Dec 25 2014
5 comments
1,050 views