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.