Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with dblink - ORA-02085

R. RoyalMar 3 2008 — edited Mar 3 2008
I create dblink MY_LINK, but when I run:

select *
from city@MY_LINK

I get:
ORA-02085: database link MY_LINK connects to ORCL2

If I run:
alter session set global_names=false, the query run correctly
Now I must schedule one job with dblink MY_LINK every day.

How can I change global_names to run correcly the database link MY_LINK always?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2008
Added on Mar 3 2008
#general-database-discussions
5 comments
1,030 views