Cannot create db-link between different platform, help!
From: (wrong string) 常山趙子龍 <abc_at_x.y.z>
Date: Fri, 6 Dec 2002 13:30:22 +0800
Message-ID: <aspcd2$eoj_at_netnews.hinet.net>
Date: Fri, 6 Dec 2002 13:30:22 +0800
Message-ID: <aspcd2$eoj_at_netnews.hinet.net>
[Quoted] I need your help!
[Quoted] 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 - 06:30:22 CET