ORA 02069: global_names parameter must be set to TRUE

- Oracle-Developer.com -

ORA-02069: global_names parameter must be set to TRUE
Comment on this Topic

If you get this error while trying to access a table over the database link.

This error happens when the database parameter global_names is set to TRUE.

When this is the case, the database link need to have the same name as the global name of the remote database (the one you are trying to connect to).

You can find out if global_names is on by using:

SQL> show parameter global_names

Find out the global name of the remote database. Log into the remote database and use:

SQL> select * from global_name;
GLOBAL_NAME
-------------------------------------------------------------------
> DB1.ORACLE-DEVELOPER.COM

Create the database link in the Oracle database appropriately
SQL> create database link DB1 connect to scott identified by tiger using 'DB1';

Oracle also publishes something similar to following for this error (quick work around if it is possible for you to use):

- ORA-02069: -
- global_names parameter must be set to TRUE for this operation -

- Cause: -
- A remote mapping of the statement is required but cannot be achieved because GLOBAL_NAMES should be set to TRUE for it to be achieved. -

- Action: -
- Issue ALTER SESSION SET GLOBAL_NAMES = TRUE if possible. -

Comment on ORA-02069: global_names parameter must be set to TRUE

Owned and Operated by Varun Jain, Inc, an Oracle Consulting Firm