Thank you that was the trick. Password was correct, but because of 11g password checking, you have to enclose the password in double ticks "password".
harel safra wrote:
Make sure that the username and password are indeed correct in the db
link creation command.
By default the password in oracle 11g is case sensitive, unlike
previous versions.
Harel Safra
On Wed, Jan 27, 2010 at 10:57 PM, Rodd Holman <rodd.holman@xxxxxxxxx
<mailto:rodd.holman@xxxxxxxxx>> wrote:
Is XE prohibited from using db links?
...
Why does one connect and not the other? Is there something I'm
missing here or is Oracle not letting us use db links in XE?
--
//www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l
