Yes, setting GLOBAL_NAMES = FALSE will allow the DB link to work, but
if you are using Advanced Replication, GLOBAL_NAMES must be set to TRUE
and your DB links must conform to the requirement that it imposes.
Paul Baumgartel
- Scott.Shafer_at_dcpds.cpms.osd.mil wrote:
> set GLOBAL_NAMES to false from sql prompt and in the init.ora file.
> > -----Original Message-----
> > From: Denham Eva [SMTP:EvaD_at_TFMC.co.za]
> > Sent: Thursday, March 14, 2002 7:03 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: DB Link Problem
> >
> > Hello List,
> >
> > Have a problem,
> > Oracle 817
> > Win3K sp6
> > Trying to create a DB link between the production and the test dbs.
>
> >
> > The db_link creates fine ( so it appears).
> > However when you try to run a script to reference the other, I get
> >
> > select count(*) from workorder_at_maxie
> > *
> > ERROR at line 1:
> > ORA-02085: database link MAXIE connects to MAXTEST.TFMC.CO.ZA
> >
> > I checked out the manual, but it seems as thou I have created the
> link
> > correctly.
> > I also checked out metalink, which suggested changing the
> global_name with
> >
> > ALTER DATABASE RENAME global_name TO MAXTEST
> > But this causes the following error:
> > ORA-02019: connection description for remote database not found.
> >
> > Has anyone got any ideas? Is this a bug?
> >
> > TIA
> > Denham
> >
> > _____
> >
> > This e-mail message has been scanned for Viruses and Content and
> cleared
> > by MailMarshal - For more information please visit
> www.marshalsoftware.com
> > <http://www.marshalsoftware.com>
> > _____
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Scott.Shafer_at_dcpds.cpms.osd.mil
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: treegarden_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Mar 14 2002 - 09:58:51 CST
