DBlink issues

Hi Team,

We are accessing remote tables using dblink. Our environment cdb with single pdb 19.17 version. Source is onpremise and target is OCI DB.

Global names parameter is false in both cdb and pdb in source. Where as in target, global names is true in cdb and it is false in pdb.

We tried to set false in target but still faced the same error.

Remote DB:

SQL> SELECT GLOBAL_NAME FROM GLOBAL_NAME;

GLOBAL_NAME

DEVDB.TTDFUSIONVCNPRI.TTDFUSIONVCN.ORACLEVCN.COM

SQL>

Source:

SQL> alter session set container=suppdb;

Session altered.

SQL> create database link DCB_xxttdociCIDB.test.ttdfusionvcnpri.ttdfusionvcn.oraclevcn.com connect to XXTBR identified by ***** using '*****:1521/erpdevdb.ttdfusionvcnpri.ttdfusionvcn.oraclevcn.com';