Dblink

Hi Team,

DB version 19.23

CDB with 2 PDB

We have created a dblink from oracle to PostgreSQL DB. When we select the data from the table , it returns below error. Our global names parameter is set to true in cdb and pdb.

SQL> select * from "designations"@mstestdb;
select * from "designations"@mstestdb
*
ERROR at line 1:
ORA-02085: database link MSTESTDB.OPCFUSVCNPRI.OPCFUSVCN.ORACLEVCN.COM
connects to HO.WORLD

SQL> select * from global_name;

GLOBAL_NAME

ERPDEVDB.OPCFUSVCNPRI.OPCFUSVCN.ORACLEVCN.COM

SQL> sho parameter global

NAME TYPE VALUE

allow_global_dblinks boolean FALSE
global_names boolean TRUE
global_txn_processes integer 1
SQL>

Will there be any impact if we set global names parameter to false?