Database link

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Thu, 12 Oct 2000 11:01:21 -0300
Message-Id: <10647.119066@fatcity.com>

Has anyone created database link from Personal Oracle 8.1.6? I have used database links with previoous versions, including Personal Oracle, and there was no problem. But 8.1.6 does not seem to like what I am doing.

Here is extract fom my tnsnames.ora:

LRMI.NOVALISTECH.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = wallyjr)(PORT = 1526))

    )
    (CONNECT_DATA =
      (SERVICE_NAME = lrmi)
    )
  )

I can connect without any problems to the database: connect wiwaniec_at_lrmi

When I create the database link:

create database link lrmi connect to wiwaniec identified by my_pass using 'lrmi'

everything seems to be OK. But when I try to use it:

select count(*) from my_table_at_lrmi;

I get the error:

ORA-02085: database link LRMI.NOVALISTECH.COM connects to LRMI I have tried all variations:
- use lrmi.novalistech.com as the database link name

use 'lrmi.novalistech.com' as connect string
use different database link name - my_lrmi, with and without the domain but each time I get the error back and the database link always has the domain suffix while the connect string does not.

The same syntax for database link works properly in Oracle 8.1.6 on UNIX when I create link to another dataabse on UNIX.

Is there something specific for Personal Oracle or am I missing something?

Thanks

Witold

Witold Iwaniec
Senior Software Developer
NovaLIS Technologies
wiwaniec_at_novalistech.com Received on Thu Oct 12 2000 - 09:01:21 CDT