Originally posted by jdorlon
Try :

CREATE PUBLIC DATABASE LINK "NEWS_DBLINK"
CONNECT TO "NEWS_OWNER.WORLD" IDENTIFIED BY "sid8" USING 'LOUISE_NEWS'

OR

CREATE PUBLIC DATABASE LINK "NEWS_DBLINK"
CONNECT TO "NEWS_OWNER.HEROLD.COM" IDENTIFIED BY "sid8" USING 'LOUISE_NEWS'

I forget exactly which syntax it wants, but it is getting
confused because of the domain name. Play around with it
a bit and please post whichever one works when you find out
so the rest of us can remember!

-John
Hi John,
I tried the following 3 syntaxes but still it does not work

CREATE PUBLIC DATABASE LINK "TEST" CONNECT TO "NEWS_OWNER"
IDENTIFIED BY "sid8" USING 'LOUISE_NEWS' ;


CREATE PUBLIC DATABASE LINK "TEST1" CONNECT TO "NEWS_OWNER.WORLD" IDENTIFIED BY "sid8" USING 'LOUISE_NEWS'

CREATE PUBLIC DATABASE LINK "TEST2" CONNECT TO "NEWS_OWNER.HEROLD.COM" IDENTIFIED BY "sid8" USING 'LOUISE_NEWS'

Also the db_domain parameter in both the databases is set to World.

Also I noted one thing that I am able to create a db link from sid8 to sid7 like thes and it is working fine

CREATE PUBLIC DATABASE LINK "TEST2" CONNECT TO "COMPANY" IDENTIFIED BY "company" USING 'LOUISE_COMPANY'

why is it not allowing me to use the link from sid7 to sid8 then.

Please suggest.

Thanks a Lot
Anurag

[Edited by anuragmin on 07-23-2001 at 11:15 AM]