ORA-600 [ksmcat: no current call heap] Error On Remote Gateway Query
(Doc ID 1385437.1)
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.
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|