I tried running only MERGE statement using DB Link.
Could you suggest.
MERGE INTO XXF_GL@XXINDB.MER.COM ENTITY -- DB link
USING (SELECT A.FLEX_SEGMENT_VALUE ENTITY_ID,
B.NAME
FROM GL_LEGAL_ENTITIES_BSVS A,
XLE_ENTITY_PROFILES B,
HR_OPERATING_UNITS C
WHERE A.LEGAL_ENTITY_ID = B.LEGAL_ENTITY_ID
AND C.DEFAULT_LEGAL_CONTEXT_ID = B.LEGAL_ENTITY_ID) e
ON (ENTITY.TSF_ENTITY_ID = e.ENTITY_ID)
WHEN NOT MATCHED THEN
INSERT(TSF_ENTITY_ID,TSF_ENTITY_DESC)
VALUES(e.ENTITY_ID,e.NAME);
SQL Error: ORA-02070: database does not support in this context
02070. 00000 - "database %s%s does not support %s in this context"
*Cause: The remote database does not support the named capability in
the context in which it is used.