ORA-600 [ksmcat: no current call heap] Error On Remote Gateway Query
Last updated on FEBRUARY 07, 2014
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Information in this document applies to any platform.
... ksmcat kqlnrc kglgpr kgiina kgiinp peiinspbn kkxpispbn kgmexec evapls evaopnc rpiswu2 evaopn2 qerocnClose qerocCloseReal kxsffir kxsFreeWorkArea kxsFreeExecutionHeap kksParseCursor opiosq0 kpooprx kpoal8 opiodr ...
Additionally, when trying to insert a value into a table extracted from a remote table via Heterogenous Services, such as:
insert into scott.my_tables select TABLE_NAME TAB_NAME_S,
upper('T_' || TABLE_NAME) TAB_NAME_B,
from ALL_TAB_COLUMNS@remotedb where rownum = 1;
this errors with:
ORA-02055: distributed update operation failed; rollback required
ORA-02047: cannot join the distributed transaction in progress
Inserting directly into the table works though, as does executing the remote database SELECT query.
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