RE: Problem in creating DB Link

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_at_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: dmit_at_beaconhouse.edu.pk
> >
> > 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: ListGuru_at_fatcity.com (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: eshevtsov_at_detmir.ru
>
> 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: ListGuru_at_fatcity.com (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: dmit_at_beaconhouse.edu.pk
>
> 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: ListGuru_at_fatcity.com (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: eshevtsov_at_detmir.ru

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: ListGuru_at_fatcity.com (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).