Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle DATABASE LINK
Hi,
No, this parameter must be set to false.
Andrew Protasov
> Set the GLOBAL_NAMES parameter in init.ora file to true. This will solve
> your problem.
>
> Alex Norman
>
> mateev_at_geocities.com wrote:
>
> > I made database link between two ORACLE Instances with this
> > SQL statement:
> >
> > create database link SEC_DB_LINK
> > connect to MYNAME
> > identified by MYPWD
> > using 'SEC_DB';
> >
> > I received error message ORA-02085 when I use this database link, because
> > SEC_DB_LINK is
> > not equal to SEC_DB.
> >
> > However I see this SQL statement create properly worked
> > database link on another ORACLE server.
> >
> > Can anyone help me?
> >
> > Georgy Mateev
> > mateev_at_geocities.com
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
>
Received on Mon Nov 16 1998 - 00:00:00 CST