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: QuestionExchange <USENET_at_questionexchange.com>
Date: 26 Oct 1999 1:58:32 GMT
Message-ID: <2129qx@questionexchange.com>


You database link has to specify what database to connect to. consider - when you do "connect system/manage_at_db1" the db1 refers to the tnsnames file which specifies the ORACLE_SID and location of the database. Your link HAPPENS to be called db1 but the same reference isn't going to take palce without the using clause.
The .."emp_at_db1" references the link which as created only specifies WHO to connect to not WHERE. Examine the database link syntax again and be sure to specify the using clause. Becca
> 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
>
>
>
>

--
  This answer is courtesy of QuestionExchange.com   http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6325&cus_id=USENET&qtn_id=6286 Received on Mon Oct 25 1999 - 20:58:32 CDT

Original text of this message

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