Ok tried what you said...and here's what I got. I'm still missing
Database link created.
SQL> select a.firstname, a.lastname, b.fname, b.lname
3 where upper(a.lastname) like 'AR%'
4 or upper(b.lname) like 'AR%'
ERROR at line 2:
ORA-12154: TNS:could not resolve service name
Any ideas, I really your patience and help
>The Cnnect Sring is user defined when you set up your TNSNAMES.ORA file (if
>you take that route). In the case of a DB link, connect string used is the
>one from TNSNAMES.ORA file on your server, so you have to ensure that
>there's consistency across your system.
>The naming convention we use is Server_Application_Environment, so an
>example would be: DBS1_ACCT_TEST, DBS1_ACCT_PROD etc..
>> can you give an example of a remote conect string??
>> On Thu, 1 Mar 2001 09:56:10 +0100, "Ian Ledzion"
>> >Have you tried a Database link?
>> >CREATE DATABASE LINK my_link USING '<remote_connect_string>';
>> >You can refer to tables in the remote DB using:
>> >> I'm have oracle 8.1 client installed on my NT box and two databases I
>> >> have access to via tcp/ip and mention in tnsnames.ora. Is there a way
>> >> via sql to access both databases at the same time and do a simple
>> >> join...like lastname to lastname???
>> >> If not are there ways of doing this? do I need third party software?
>> >> any help , or directions to the right spot would be greatly
>> >> appreciated.
>> >> regards,
>> >> Will Kramer