Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database link
You need to use:
create database link dblink
connect to billusr01 identified by billusr01 using 'connect_string';
Where connect_string is a valid entry in the tnsnames.ora file. i.e. on the a valid entry on the server machine and not the client machine.
If you dont use connect to .... then you will be connected with your current username and passwd.
Hope this is useful
Tony Adolph
In article <36f7041f.88346826_at_butler.psa>,
chong_at_hq.psa.com.sg wrote:
> 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_remotedb';
>
> note: remotedb the SID of the remote database.
>
> SQL> describe user_tables_at_dlink;
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 23 1999 - 10:31:57 CST