Re: How ro create a database link

Hi Uwe,

I have not tried this but my notes indicate that if you have GLOBAL_NAMES set to TRUE in initXXXX.ora, then it forces the database link name to be named same as the target database name.

I cannot shed any more light on it.

Suresh Bhat

Uwe Schneider <uwe.schneider_at_xlink.net> wrote in article <38281AF5.90CA97B0_at_xlink.net>...
> 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 - 16:21:58 CST