Andrea,
When GLOBAL_NAMES=TRUE then the name of the db link
must match the global name of the db to which it
connects. You can check the global_name with
SELECT * FROM GLOBAL_NAME;
In your case the global_name of the remote db is
AU34TD.WORLD so you will get this error unless you
name the db link AU34TD.WORLD.
You can set GLOBAL_NAMES=FALSE, as long as you are not
using something, such as replication, which requires
this to be true.
You can alter the global name of a db using
ALTER DATABASE RENAME GLOBAL_NAME TO
<newname.domain>;
WARNING: Never alter the global name of a db that is
already part of an advanced replication environment or
you will break the replication environment.
HTH,
-- Anita
--- Andrea Oracle <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I tried to create a database link like this:
>
> create database link test connect icssowner
> identified
> by icssowner using 'AU40CNV';
>
> when I used it, I got:
> ERROR at line 1:
> ORA-02085: database link TEST.WORLD connects to
> AU34TD.WORLD
>
> I created other links to AU40CNV, but I got that err
> again, the link ALWAYS goes to AU34TD.WORLD!!! why?
>
> Thanks
>
> Andrea
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great
> prices
> http://auctions.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Andrea Oracle
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
