Re: Database Links

Jason.
You have 2 choices:
1) Give the db link the same name as the database to which it connects. 2) Set the initialization parameter GLOBAL_NAMES to FALSE (in init.ora file or using ALTER SESSION or ALTER SYSTEM commands)

tdrudy_at_ix.netcom.com wrote:

> Doesn't make sense: you can name the db link anything you want.
> What's the error identifier (e.g., ORA-00902) ?? db links aren't
> that tricky, so can you give me some more info?
>
> Tom Rudy
>
> Jason Berriman wrote:
> >
> > Hi all,
> >
> > I'm havea small problem with database links.
> >
> > I have a script which compares two schema's by using a database link, but I
> > keep getting the error saying that the database link name must be the same
> > as the database name that you are connecting to.
> >
> > The script that a was given creates a link called aaalnk, does anybody know
> > whats going on ?
> >
> > (I'm 7.3.3 and the script was written for 7.3)

--
====================================================
Oren Nakdimon
Golden Screens Ltd.
address: 17 Abba-Hillel st., Ramat-Gan 52522, ISRAEL
email:   oren_at_gsit.co.il
tel:     +972-3-7510836
fax:     +972-3-7518221
====================================================