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: 155

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

Related posts about sql

Related posts about Oracle