Oracle global_names DELETE problem
Posted
by
jyzuz
on Stack Overflow
See other posts from Stack Overflow
or by jyzuz
Published on 2010-12-28T15:44:25Z
Indexed on
2011/01/04
18:54 UTC
Read the original article
Hit count: 183
I'm using a database link to execute a DELETE statement on another DB, but the DB link name doesn't conform to global naming, and this requirement cannot change. Also I have global_names set to false, and cannot be changed either.
When I try to use these links however, I receive:
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 is the alternative action when setting global_names=true
is not possible?
Cheers,
Jean
© Stack Overflow or respective owner