OraFAQ Forum: SQL & PL/SQL » ORA-02069: global_names parameter must be set to TRUE for this operation

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02069: global_names parameter must be set to TRUE for this operation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-02069: global_names parameter must be set to TRUE for this operation [message #15190]

Fri, 24 September 2004 00:30

Steve Molloy
Messages: 1
Registered: September 2004

Junior Member

I'm using database links where the link name doesn't conform to�global naming, this is a requirement that cannot be changed. Consequently I have global_names set to false. 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,

Steve.

Report message to a moderator

Previous Topic:	monitor index
Next Topic:	Dept wise highest 2 or 3 Salaries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 25 01:40:57 CDT 2025