2011-01-03

ORA-00600: internal error code, arguments: [kdiblsorget:rowidIllegal]

Bug 5331374  OERI [kdiblsorget:rowidIllegal] updating partitioned table with row migration

When updating a partitioned table where row migration is enabled,and where there are bitmap indices defined, an update could result in  ORA-600[kdiblsorget:rowidIllegal]. 


ORA-600 [kdiblsorget:rowidillegal] Received From Direct Load SQL*Loader [ID 1073376.1]

Modified 26-APR-2010     Type PROBLEM     Status PUBLISHED


Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Target table is partitioned with row_movement disabled.

Tablespace where the table resides is 32k block size.

DB_block_sike is 8k.


Running sqlloader in direct load mode:

sqlldr userid=user1/passwd1@mydb control=table1.ctl direct=true
fails with errors:

SQL*Loader-961: Error calling once/load finishing for table user1.table1
ORA-00600: internal error code, arguments: [kdiblsorget:rowidIllegal], [8], [8], [], [], [], [], [], [], [], [], []
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

If conventional load mode is used, the load operation completes successfully


.

Cause

This is logged in Bug:8602289 which has been marked as a duplicate of Bug:9325889 currently being investigated by development.

Solution

Until the bug is fixed, these are the workarounds available:

1.  Run the sqlldr in conventional mode

2.  Move the table to a tablespace which has a blocksize the same as the db_block_size.

Niciun comentariu:

Trimiteți un comentariu