Re: How ro create a database link

Mehul Zaveri wrote:
>
> It should work, you just need to give the connect string of the same db.
> What name you give to dblink would be immatrial!
> You can have multiple dblinks pointing to same db and can be itself also.

That is what I thought also. But:

SQL> create public database link C connect to <user>

     identified by <pass> using 'C';

database link created

SQL> select * from table_at_C;

ORA-02085: database link C.WORLD connects to D.WORLD

("D" is the SID in tnsnames.ora, C is the alias used as connect string)

Hmmh...

--
uwe.schneider_at_xlink.net Received on Tue Nov 09 1999 - 07:00:37 CST