Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle DATABASE LINK

Re: Oracle DATABASE LINK

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: 1998/11/16
Message-ID: <AArO9KsK42@protasov.kiev.ua>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US