Re: Cannot create db-link between different platform, help!
Date: Fri, 06 Dec 2002 09:25:35 -0600
Message-ID: <s5g1vuo4c3qebif3otgb4a7fjo35gtab1j_at_4ax.com>
The message is telling you that the database you want to connect to has a different global name then the name of the link you created... when GLOBAL_NAMES=TRUE in the init<sid>.ora file any database link connecting to it must be named the same as the database..The error message should have given you that name....( where you have the second 'string' in your posting) hth,
"常山趙子龍" <abc_at_x.y.z> wrote:
>
>I need your help!
>
> I use Oracle 8.1.6.
>
> I'd like to create a db-link from oracle on windows2000 to the other oracle
>on sun solaris.
>
> But it doesn't work!
>
> And It works if I create a db-link from oracle on linux to the oracle on
>sun solaris.
>
> The following is the script what I write :
>
> CREATE PUBLIC DATABASE LINK TEST_LINK
> CONNECT TO ADM IDENTIFIED BY ADM
> USING 'db_string'
> /
>
>When I Query by this db link,
>
>select * from table_name_at_test_link
>
>the error message:
>
>ORA-02085 database link string connects to string
>
>By the way, I created synonyms for the table_name.
>
>
>Thanks for Help!!!!!!
>
>
Received on Fri Dec 06 2002 - 16:25:35 CET