KETTLE 往oracle存数 报ORA-00600：内部错误参数[Kqd-objerror$],[U],[0],[107],[CS],[]

检查ORACLE数据的有个CS触发器编译报错，这个问题就是这个 trigger 状态是失效的(invalid) , 但 complie 又过不了, 要 drop 又会报物件失效无法 drop , 所以需在 sys.objerror$ 将他登记进去 , 才能 drop

Do you have this kind of error message ?

SQL> drop user MYUSER cascade;
drop user MYUSER cascade
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqd-objerror$], [U], [0], [101],
[MYTRIGGER_MYCALCULATION], [], [], [], [], [], [], []
It means that one or more object is invalid. And in the error message you have the object name causing this error and then you can find the ids of instances of this object causing errors.

SQL> select object_id f