Hi,

I encountered a db-link problem;

When I create a db-link as sys on the first database using the following script ( to access the second database on the same server) ;

CREATE PUBLIC DATABASE LINK "DBname"
CONNECT TO "user"
IDENTIFIED BY "********"
USING 'Second Database'

I try to connect to by this link using SQL*PLUS the error ORA-00942 pops up. This probably indicates this is a privileges issue but what privs do I have to set ( and on which database ) to connect to the second database.

select count(*) from DBname.table;

Please push me in the right direction.

GKramer