Aleem, The keyword PUBLIC is not required and that's the difference between creating public and private db links. Have a look at SQL Reference Giude. If my memory serves me right Oracle don't support describe for a remote table. It's OK that Oracle append us.oracle.com to the name of your db link. Have a look at parameter DB_DOMAIN, it should be described in your init.ora and sqlnet.ora files. Default value is 'WORLD'.
Regards, Ed > > > 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). > -- 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).
