Aleem, Cany you tnsping the abc database from the server which the database with the link resides on.
Can you do a select * from dba_db_links and see if you can see the link and the owner. Also can you advise exactly how you are doing the drop and from which user? Iain Nicoll -----Original Message----- Sent: Monday, August 26, 2002 11:08 AM To: Multiple recipients of list ORACLE-L 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: Nicoll, Iain \(Calanais\) 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).
