Linking to tables in another database?!?

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