Re: Database Link Error

Try the following:

ALTER sesion set global_name = false.

This should do it. this makes it false for the session you are in. Of course if u want it globally, you need to change INIT.ORA. Consult your DBA before doing this.

devdew

sybrandb_at_my-deja.com wrote:

> In article <3997a240.0_at_mercury.planet.net.au>,
> "Katherine Coombes" <kcoombes_at_clinicalsys.com.au> wrote:
> > I have been trying to link to a remote database using the "create
 public
> > database link DBLink Connect to username identified by password using
> > tnsnames.ora entry". The link appears to be created OK however when I
 try
> > and use the link for data I get "ORA 02085 - database linke
 adltlink.world
> > connects to adlt.world". I can connect to both databases using the
 UserId
> > password combo. Has anyone had this problem or know of a solution for
 it?
> >
> > Many thanks.
> >
> >
>
> Your global_names init.ora parameter is true.
> This means all link names should have the same name as the database you
> are linking to. Either change the parameter or change the link name.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------------------------------
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Aug 14 2000 - 12:08:58 CDT