Thank you Edward, As suggested, I have tried the following command (since PUBLIC is required) CREATE PUBLIC DATABASE LINK my_link CONNECT TO UserA1 IDENTIFIED BY passwordA USING 'abc'
The Server B from where I am issuing this command, connects to the Server A using the same connect string 'abc'. After this connection I am able to view tables, data etc. But the command describe table1@my_link seems to be liking the error ora-02019: connection description for remote database not found. The view all_db_links lists this link but appends us.oracle.com to my_link under db_link column. Any more suggestions For dropping the link, I was missing "PUBLIC" keyword Aleem -----Original Message----- Sent: Monday, August 26, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: Problem in creating DB Link Hi Aleem, Just try to create a simple link without PUBLIC and SHARED keywords if you don't really need them. Login as user B and issue the following command: CREATE DATABASE LINK mydblink CONNECT TO userA IDENTIFIED BY password_of_userA USING 'abc'; If you get ORA-02019 then check if the correct service name (abc in that case) exists in your tnsnames.ora on server B. You can use TNSPING abc to ensure that your service name points remote db properly. Regards, Ed > > Hi, > > I have created a Database Link under the scenario detailed > below: but when I try to access tables through the link it gives error > ORA-02019: connection description for remote database not found. > > If I try to drop the link it gives error > ORA-02024: database link not found > > TIA! > > Aleem > > > This is the scenario: > We have two db servers running on our LAN, for simplicity > 'A', connect string 'abc' and 'B', connect string 'xyz'. > > Some of the tables on A in schema UserA1 are required (read > only) by schema UserB1 on server B. As suggested by someone I > tried to create a dblink. Using SQL*Plus connected as > 'System' to Server B (since it requires to access tables from > the other db) and applied the following command. > > CREATE SHARED PUBLIC DATABASE Link my_link > CONNECT TO UserA1 IDENTIFIED BY abc > AUTHENTICATED BY UserB1 IDENTIFIED BY def > USING 'abc' > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Abdul Aleem > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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).
