My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.