Re: remote access

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Fri, 20 Nov 98 10:45:37 +0200
Message-ID: <ABnmILsK42@protasov.kiev.ua>

Hi,

Try

create database link dlink
connect to billusr01 identified by billusr01 using 'powprodb';

Andrew Protasov

> Hi, I am trying to access a remote database using database link
> but I keep encountering hitting some error messages. I will be glad if
> someone could point out my mistakes or how to troubleshoot them.
>
> What I did:
>
> SQL> create database link dlink using 'billusr01/billusr01_at_powprodb';
>
> note: powprodb is the SID of the remote database.
>
> SQL> describe user_tables_at_dlink;
> ERROR:
> ORA-12154: TNS:could not resolve service name
Received on Fri Nov 20 1998 - 02:45:37 CST