Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Link across 2 databases.

Re: Database Link across 2 databases.

From: LKAB <anders.alm_at_lkab.com>
Date: Fri, 22 Oct 1999 09:20:26 +0200
Message-ID: <MPG.127a2ea97472b709989680@news.norrbotten.se>


In article <7ujsh6$42t$1_at_violet.singnet.com.sg>, mikeseah_at_singnet.com.sg Hi

I had a similar problem.
I use NT4.
My problem was solved when i changed my INIT.ORA to global_names = false

Almen
says...
> greetings,
> I need to try out oracle basic replication.
> I have created 2 Oracle Databases on my PC.
> I can do a
> "connect system/manager_at_db1" &
> "connect system/manager_at_db2"
> (So TNS is ok)
> From db2, I have done a
> "create database link db1 connect scott identified by tiger;"
> but a
> "create snapshot scott.emp as select * from scott.emp_at_db1"
> fails with error:
> ORA-02019 connect desc for remote database not found.
> what is missing in the Oracle network setup ?
> Any assistance would be appreciated.
> rgds
> mike
>
>
>
Received on Fri Oct 22 1999 - 02:20:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US