Oracle global_names DELETE problem

I use a database link to execute a DELETE statement in another database, but the database link name does not match the global naming convention, and this requirement cannot change. I also have global_names set to false and cannot be changed.

When I try to use these links, I get:

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)

What alternative installation action is global_names=truenot possible?

Cheers,
Jean

+3
source share
2 answers

. GLOBAL_NAMES TRUE , , , FALSE? GLOBAL_NAMES , ?

+1

, GLOBAL_NAMES TRUE . , , GLOBAL_NAME .

, .

+1

Source: https://habr.com/ru/post/1782458/


All Articles