ORA-600 [13004] Raised With CREATE INDEX (文档 ID 1667585.1)

本文详细介绍了在使用Oracle Database Standard Edition版本10.2.0.4及以上版本时，遇到创建索引失败导致ORA-600[13004]错误的解决步骤。提供了工作绕过方法和数据迁移解决方案，帮助快速定位和修复问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

修改时间:2014-6-11

类型:PROBLEM

In this Document

APPLIES TO:

Oracle Database - Standard Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

SYMPTOMS

Index creation fails with ORA-600 [13004] like below:

          SQL> CREATE  INDEX "owner"."Index_name" ON "owner"."table_name" ("column_name") TABLESPACE "tablespace_name";
         
 CREATE  INDEX "owner"."Index_name" ON "owner"."table_name" ("column_name") TABLESPACE "tablespace_name"
         
 *
         
 ERROR at line 1:
         
 ORA-00600: internal error code, arguments: [13004], [], [], [], [], [], [], []

The call stack from the trace file includes functions like:

... ksedmp kgeriv kgesiv ksesic0 qerliRop qerstRowP qersoFetch qerstFetch qerliFetch qerstFetch kdicrws kdicdrv opiexe opiosq0 kpooprx kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv ...

CAUSE

There may be some memory corruption which was however not verified in this case.

The issue also resembles
Bug 6654203 - WORKFLOW INDEX ONLINE REBUILD FAILS WITH ORA-600 [13004]
closed as duplicate of
Bug 4655998 - OERI / dump from SQL involving SORT operations
which is already fixed in 10.2.0.4

SOLUTION

As a workaround, first try:

Set _newsort_enabled to FALSE in the init.ora, restart the instance, and create the index.

If the above does not solve the problem, then:

Take an export of the table and import into another tablespace and then try to recreate the index.

1. Take export of the table
2. Drop the table
3. Import in different tablespace
4. Recreate the index

REFERENCES

NOTE:434203.1 - ORA-00600 [13004]
NOTE:28230.1 - ORA-600 [13004]
NOTE:729170.1 - ORA-00600 [13004] During Import And/Or Index Creation.
NOTE:1507047.1 - ORA-00600: Internal Error Code, Arguments: [13004], [], [], [], [], [], [], [], [], [], [], []
NOTE:453186.1 - How to move LOB Data to Another Tablespace when the Table also contains a LONG column