Re: Linking to tables in another database?!?

> After checking the server, there seems to be no TNSNAMES.ORA file with
> an equivalent entry. Do I need to create an entry for 'LIVE' in the
> TNSNAMES.ORA file on the server before this will work?
Yes, database link processing is done by the server only.

Hth,

Sybrand Bakker, Oracle DBA

Steve Roberts <steve_at_back2front.co.uk> schreef in berichtnieuws 4aj1jsckkbvbq5oe114ueccvn2f3euoejk_at_4ax.com...
> Hello,
>
> I would very much appreciate any help with the following problem I am
> having with Oracle 7.3 -
>
> We are running two instances, TRIAL and LIVE, on a Unix box.
> I would like to be able to create a read-only link from TRIAL to
> various tables in LIVE so that I can perform tests using the latest
> data.
>
> I have tried using the following statement to create the link -
>
> CREATE DATABASE LINK SYNTECH_ON_LIVE
> CONNECT TO SYNTECH IDENTIFIED BY <password>
> USING 'LIVE';
>
> However, after creating the above link and referring to a remote table
> using...
>
> SELECT * FROM SYN_PEPERSON_at_SYNTECH_ON_LIVE;
>
> ...I get the error message 'ORA-12154 TNS:could not resolve service
> name'.
>
> 'LIVE' has been set up in TNSNAMES.ORA on the client side which the
> system resolves to the correct TCP/IP address when connecting via
> SQLPlus for example.
>
> After checking the server, there seems to be no TNSNAMES.ORA file with
> an equivalent entry. Do I need to create an entry for 'LIVE' in the
> TNSNAMES.ORA file on the server before this will work?
>
> Many thanks in advance.
>
> Steve Roberts
> Back-to-Front Solutions Limited
> (steve_at_back2front.co.uk)
Received on Sun May 28 2000 - 00:00:00 CDT