ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70000029A6C9410], [],(三)

OBJECT_NAME OBJECT_TYPE OWNER STATUS
-------------------- ------------------- ---------- -------
VW_EBAY_MAIL_CLCT VIEW EMSTRC VALID
VW_EBAY_MAIL_CLCT SYNONYM EMSQUERY INVALID

果然失效了。注意在10g中，同义词失效，但是还是可以查询的：

select count(*) from vw_ebay_mail_clct;

COUNT(*)
------------------
3398700

重建同义词：

create or replace synonym VW_EBAY_MAIL_CLCT for emstrc.VW_EBAY_MAIL_CLCT;

重新查询状态：

SQL> SELECT object_name,object_type,owner,status
2 FROM dba_objects
3 WHERE object_name='VW_EBAY_MAIL_CLCT';

OBJECT_NAME OBJECT_TYPE OWNER STATUS
-------------------- ------------------- ---------- -------
VW_EBAY_MAIL_CLCT VIEW EMSTRC VALID
VW_EBAY_MAIL_CLCT SYNONYM EMSQUERY VALID

状态已经变为valid了。

参考文档：

How To Find The Object That Causing ORA-600 [kqlnrc_1] [ID 1190673.1]