Set global_names=false in oracle
630732Jan 8 2009 — edited Jan 8 2009Hi,
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