Error ORA-00600 when applying changes to table indexes

[Fulvio Bertino]

When trying to add a bitmap index and a normal index to a table already having an index, using the "edit table" functionality, the plsqldev causes an error ORA-00600.
The same exact operation with sqlplus doesn't give me any problem.
Here there are a few details:

/orasystembe/OraBE/udump/orabe_ora_26299.trc Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /u01/app/oracle/product/9.2.0.5
System name: HP-UX
Node name: dctst01
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: OraBE
Redo thread mounted by this instance: 1
Oracle process number: 817
Unix process pid: 26299, image: oracle@dctst01 (TNS V1-V3)

*** 2005-04-04 12:46:57.966
*** SESSION ID525.5187) 2005-04-04 12:46:57.935
********** Internal heap ERROR 17113 addr=0000000000000000 *********
******************************************************
HEAP DUMP heap name="" desc=0000000000000000
extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0
parent=0000000000000000 owner=0000000000000000 nex=0000000000000000 xsz=0x0
Hla: -1
*** 2005-04-04 12:46:57.988
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17113], [0x000000000], [], [], [], [], [], []
Current SQL statement for this session:
BEGIN
aw_drop_proc(ora_dict_obj_type, ora_dict_obj_name, ora_dict_obj_owner);
END;
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+184 ? ksedst() 4000000001699D43 ?
000000031 ? 000000000 ?
4000000002E5E107 ?
ksfdmp()+32 ? ksedmp() 800003FFC0002BE8 ?
800003FFC0000610 ?
800000010000B0C0 ?
000000000 ?
kgeriv()+152 ? ksfdmp() 800000010000B0C0 ?
000000000 ? 000000000 ?
80000001000DA6C0 ?
kgesiv()+132 ? kgeriv() 80000001000DA6C0 ?
42D900000002 ? 000000000 ?
000000000 ?
kgesic1()+84 ? kgesiv() 40000000013F15DF ?
40000000014778BB ?
4000000001452D4F ?
000000000 ?
kgherror()+1288 ? kgesic1() 4000000001452D4F ?
000000000 ? 000000120 ?
4000000001477A43 ?
kghgex()+876 ? kgherror() 800003FFC00028F0 ?
000000000 ? 000000000 ?
000000000 ?
kghfnd()+628 ? kghgex() 4000000002E6162B ?
000000000 ? 000002000 ?
000001000 ?
kghprmalo()+296 ? kghfnd() 800000010000B948 ?
000000000 ?
800000010000B948 ?
800003FFC0002518 ?
kghalp()+524 ? kghprmalo() 000000000 ? 000000000 ?
000000000 ?
80000001000CDE38 ?
parchk()+776 ? kghalp() 000000000 ? 000000000 ?
400000000089FA88 ?
40000000015C098F ?
ptmak()+244 ? parchk() 80000001000D7D80 ?
40000000015674F3 ?
800003FA8002F400 ?
40000000016ED5C3 ?
pdtidc()+5984 ? ptmak() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
pdlifu()+696 ? pdtidc() 5555555500000002 ?
5555555555555555 ?
80000001000CDE38 ?
800003FFC0000E00 ?
phpcog()+24 ? pdlifu() 000020000 ?
80000001000CDE38 ?
00000001A ? 000000000 ?
phpcmp()+1772 ? phpcog() 00000001A ? 000000000 ?
C0000001A3C5025C ?
000000000 ?
pcicog()+196 ? phpcmp() 000000000 ?
C0000001B1EC3A88 ?
00000001A ?
40000000004E53B8 ?
kkxcog()+320 ? pcicog() 800003FAC0056BF8 ?
800003FAC005FEA0 ?
800000010000B948 ?
4000000001564583 ?
opitca()+4808 ? kkxcog() 80000001000CDE38 ?
000000000 ?
80000001000CDE38 ?
400000000139E017 ?
kksctca()+32 ? opitca() 0000CDE38 ? 00000000C ?
800000010000BA20 ?

 

[Marco Kalter]

It seems that the error is caused by a DDL trigger. Do you have any DDL triggers? Can you disable them and try again?

 

[Fulvio Bertino]

I confirm you the error is due to a ddl trigger.
The problem is that this ddl trigger is a system trigger created when the OLAP feature is enabled.
Our DBA obviously say they can't disable a system feature just because an application doesn't work with it... Furthermore, sqlplus works prefectly...

Here it is the trigger description we have...

Rem
Rem $Header: catxs.sql 28-jun-2002.12:48:44 zqiu Exp $
Rem
Rem catxs.sql
Rem
Rem Copyright (c) 2001, 2002, Oracle Corporation. All rights reserved.
Rem
Rem NAME
Rem catxs.sql - eXpreSs Catalog creation
Rem
Rem DESCRIPTION
Rem This loads the catalog for the analytic workspaces
Rem
Rem MODIFIED (MM/DD/YY)
Rem zqiu 06/28/02 - backport:trigger to clean up aw$, ps$ when user table is gone.
Rem jcarey 10/18/01 - remove lobtab from aw$
Rem esoyleme 09/25/01 - esoyleme_txn100146
Rem esoyleme 09/13/01 - views in spec..
Rem esoyleme 09/10/01 - creation
...
...

CREATE OR REPLACE TRIGGER aw_drop_trg AFTER DROP ON DATABASE
BEGIN
aw_drop_proc(ora_dict_obj_type, ora_dict_obj_name, ora_dict_obj_owner);
END;
/
~
~

 

[Marco Kalter]

What happens if you run the same SQL in PL/SQL Developer's Command Window?