The user i am trying to connect to is called news_owner.

I tried this also but it does not work.

CREATE PUBLIC DATABASE LINK "TEST4" CONNECT TO "NEWS_OWNER"
IDENTIFIED BY "sid8" USING 'SID8.WORLD'

Actually its ok that it is not working because i have no service name defined as sid8.world. The service name I have defined on the server side tnsnames.ora is louise_news and even with that it does not work.


Please Help.

Thanks
Anurag