user10956040 wrote:Why are you hijacking someone else's thread? This just makes it harder to deal with the OP's issue, even if you think it is closely related to yours, and you haven't given any indication that it is at all related.
I have a DB link called "appdb.message.oracle.com".I have two cars in my garage. One works. One doesn't. Why so?
In 10g "select * from table@appdb;" is working fine but in 11g not.
In 11g if i create DB link with the name "appdb" only then the query "select * from table@appdb;" is working fine.Help us to help you by giving us some clues. Given my comments above, preferably in your own thread.
Is there any update in 11g regarding this DB link names.
Plz help me out..
Thanks in Advance,