ORA-600 [kdsgrp1] Due To Naming Rules Violation

(Doc ID 2096686.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

ORA-600 [kdsgrp1] due to Naming Rules Violation

E.g.: A query like the one below will fail with ORA-600 [kdsgrp1] if "TB01" has an index named "IDXTB01~0"

SQL> SELECT "NAME","LENGTH","DATA" FROM "TB01" WHERE "CLIENT"=:A0 AND "ID"=:A1

 

============
Plan Table
============
-------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
-------------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 2 | |
| 1 | TABLE ACCESS BY INDEX ROWID | TB01 | 13 | 15K | 2 | 00:00:01 |
| 2 | INDEX RANGE SCAN | IDXTB01~0| 13 | | 1 | 00:00:01 |   <<<<<<<<<<<<<<<<
-------------------------------------------------+-----------------------------------+

Call stack: kdsgrp1_dump <- kdsgrp1 <- kdsgrp_cb <- ktrexc <- kcbgtcr <- ktrgtc2 <- kdsgrp <- qetlbrcb <- qertbFetchByRowID 

Cause

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 hundreds of Community platforms