Setting GLOBAL_NAMES = TRUE when there are active database links from Oracle DB to SQL Server DB
Can we set GLOBAL_NAMES = TRUE when there are active database links from Oracle DB to SQL Server DB?
I went through the Oracle DB link documentation, googled about it, but have not been provided any concrete answer related to it.
As per ChatGPT, "
Set GLOBAL_NAMES = FALSE
if your database uses database links to non-Oracle systems like SQL Server.
It’s the official Oracle recommendation in such cases — because GLOBAL_NAMES = TRUE
is meant to enforce global name checks only useful for Oracle-to-Oracle links."
I have been trying to find any official documentation or reference for it, but came up empty.