Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Link across 2 databases.
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