DB Link with GLOBAL_NAME=FALSE?
GaffAug 6 2009 — edited Aug 11 2009Hi:
I created a DB Link between two instances (10g) and it wouldn't work unless I set the parameter GLOBAL_NAME=FALSE. If I don't want to change the parameter, how can I get that link to work? Does the name of the link have to be identical to the global name of the destination instance (e.g. FOO.REGRESS.RDBMS.DEV.US.ORACLE.COM) or something instead of just "FOO"? Isn't that name too long for an oracle object name?
Thanks