Re: error using/creating db link

You have 'global names' enabled, which means the database link and the database must have the same name.

To demonstrate this, try:

    create database link oracle

        etc.

to create a database link, and you should find that 'select cols form table_at_oracle' will work.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Micha Huybrechts wrote in message <7pgkka$i8i$1_at_reader1.wxs.nl>...
>When we try to create a DB link, it seams it succeeds. However when I try
to
>use the link I receive ORA-02085: database link TESTLINK.WORLD connects to
>ORACLE.WORLD.
>The TNSnames.ora entry Test.world, which is used for the TESTLINK link,
>connection test works fine.
>What am I doing wrong here?
>
>Thanks in advance,
>
>Micha Huybrechts
>
>
Received on Thu Aug 19 1999 - 05:26:40 CDT