Skip to Main Content

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!

Set global_names=false in oracle

630732Jan 8 2009 — edited Jan 8 2009
Hi,
I have a doubt on where to set the global_names parameter . I mean on the remote database or the database from where you are accessing...

For ex: There are 2 databases...on 2 diff servers.....say db1 and db2

I created a database llink from db1 to db2 ...and the link is created ...

but when i try to access data through the link it does not work...it gives an error that the link name should be same as the database. This happens because global_names=true..

So i created the database link with the name db2....and now im able to access the data from remote databse.
But due to this ....i cannot keep on changing the db link name in the code everywhere...this is not feasible

My question is where to set this parameter ??
Hope it is clear
Thanks
This post has been answered by 153119 on Jan 8 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2009
Added on Jan 8 2009
2 comments
2,107 views