ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

原创 Linux操作系统 作者:kris3106 时间:2010-02-09 11:03:16 0 删除 编辑

Running into the this error for last 2 days.

Per the trace file generated, checked the SQL causing the error.

For the tables identified in the trace file,ran the following:

analyze table validate structure cascade;

The above went through fine, but the errors persisted.

Finally, identified all the indexes on the table involved and executed the following:

analyze index validate structure;

The above resolved the ORA-600 errors.

The next step, if the analyze had failed in resolving this, would have been to probably drop and recreate the indexes. I’m sure that would have resolved the error.

Apparently quite a few bugs associated with this error message and LONG columns, luckily, our table didn’t have any LONG columns or SPATIAL indexes :-)

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/563971/viewspace-627121/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-04-07

  • 博文量
    93
  • 访问量
    212697