database link problem

[GKramer]

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

[davey23uk]

select count(*) from table@dbname

[GKramer]

davey23uk

NO COMMENT ...... ( I'm embarressed ( haven't used it for a long time ) )...

Thanks anyway.

GKramer

[abhaysk]

Originally posted by GKramer
select count(*) from DBname.table;

Lemme giv some tip here, OBJECT_NAME1.OBJECT_NAME2 will mean SCHEMA.OBJECT_NAME...