ORA-600 [12804] [kkdlgtd: bad object type] Alter Table Add Column Or Running a Query (Doc ID 468435.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2
This problem can occur on any platform.

Symptoms

o A query can fail with ORA-00600: [12804], [kkdlgtd: bad object type]
if an object in the query or underlying object is missing.

o  Adding a column on a table raises ORA-600[12804]:

SQL> ALTER TABLE TB_SINACC ADD Reserve100 NUMBER(12,2) DEFAULT 0 NOT NULL ;
ALTER TABLE TB_SINACC ADD Reserve100 NUMBER(12,2) DEFAULT 0 NOT NULL
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [12804], [kkdlgtd: bad object type], [], [], [], [],
[], []


o  Stack trace looks like:

kkdlgstd kkmfcblo kkmpfcbk qcsprfro qcspafq qcspqb kkmdrv opiSem opiprs kksald rpiswu2 kkslod kglobld kglobpn kglpim kglpin kksfbc ...

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