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