ORA-00600 [kkdlGetCkyName1] When Schema Synonym Is Used
(Doc ID 2277515.1)
Last updated on AUGUST 02, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 8.0.6.0 to 12.1.0.2 [Release 8.0.6 to 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
During SELECT from a schema SYNONYM on 11g database or lower
select * from <schema>.<table_name>
the following error is raised:
ORA-00600: internal error code, arguments: [kkdlGetCkyName1]
Call stack is similar to :
[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]
[04]: kgeadse []
[05]: kgerinv_internal []
[06]: kgerinv []
[07]: kgeasnmierr []
[08]: kkdlGetCkyName []<-- Signaling
[09]: kkoiqb [SQL_Costing]
[10]: kkooqb [SQL_Costing]
[11]: kkoqbc [SQL_Costing]
[12]: apakkoqb [SQL_APA]
[13]: apaqbdDescendents [SQL_APA]
[14]: apaqbdList [SQL_APA]
[15]: apaqbd [SQL_APA]
[16]: apadrv [SQL_APA]
[17]: opitca []
[18]: kksLoadChild [cursor]
[19]: kxsGetRuntimeLock [cursor]
[20]: kksfbc [cursor]
[21]: kkspsc0 [cursor]
[22]: kksParseCursor [cursor]
[23]: opiosq0 []
[24]: kpooprx []
[25]: kpoal8 []
[26]: opiodr []
[27]: ttcpip []
[28]: opitsk []
[29]: opiino []
[30]: opiodr []
[31]: opidrv []
[32]: sou2o []
[33]: opimai_real []
[34]: ssthrdmain []
[35]: main []
[36]: __libc_start_main []
Changes
_enable_schema_synonyms set to TRUE
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |