Re: dblink problem ( ORA-02019 )

Hi,

Use
Drop database link <name.> (if the link is a private link and u are the owner)
Drop public database link <name>.

            Hope this helps
                              shreepad


                                                                                                               
                      Anand Kumar N -                                                                          
                      Systems                  To:       Multiple recipients of list ORACLE-L                  
                      <anand_at_fps.itwsig         <ORACLE-L_at_fatcity.com>                                         
                      node.co.in>              cc:                                                             
                                               Subject:  Re: dblink problem ( ORA-02019 )                      
                      16/07/02 12:33                                                                           
                      Please respond to                                                                        
                      ORACLE-L                                                                                 
                                                                                                               
                                                                                                               

HI AMJAD,
HOW TO DROP THE DATABASE LINK. ANAND
ITW SIGNODE INDIA LIMITED

• Original Message ----- From: Amjad <mailto:amjad_at_medicomsoft.com> To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Thursday, July 11, 2002 1:43 PM Subject: RE: dblink problem ( ORA-02019 )

   CREATE  PUBLIC DATABASE LINK dblink CONNECT TO user IDENTIFIED BY    password USING 'connect_string'

   Regards,
   Amjad.
   www.medicomsoft.com <http://www.medicomsoft.com>

      : root_at_fatcity.com <mailto:root_at_fatcity.com>
      [mailto:root_at_fatcity.com]On Behalf Of Anand Kumar N - Systems
      Sent: Thursday, July 11, 2002 9:33 AM
      To: Multiple recipients of list ORACLE-L
      Subject: Re: dblink problem ( ORA-02019 )


      Hi all,
      How to Create dblink, can u please explain me.

      bye
      Anand

         ----- Original Message -----
         From: Ratnesh Kumar Singh <mailto:ratnesh.singh_at_patni.com>
         To: Multiple recipients of list ORACLE-L <
         mailto:ORACLE-L_at_fatcity.com>
         Sent: Wednesday, July 10, 2002 6:23 PM
         Subject: dblink problem ( ORA-02019 )

         hi

         i have 3 databases(A,B,X) on 3 diff boxes.
         i have created 1 dblink each from A to X & from B to X.
         The syntax for dblink creation is exactly same for both dblinks.

         I am able to query from dblink A-X  as "select * from
         user.table_at_dblinkAX <mailto:user.table_at_dblinkAX>"
         but when i try to query from dblink B-X as "select * from
         user.table_at_dblinkBX <mailto:user.table_at_dblinkBX>"
         i get the foll error
         Error: ORA-02019: connection description for remote database not
         found

         When i modify my query by suffixing '.world' as
         "select * from user.table_at_dblinkBX.world <
         mailto:user.table_at_dblinkBX.world>" , the query works fine.

         I have compared the entries in init,sqlnet,tnsnmames,listener
         files on both
         A & B
         databases and they are absolutely similar .
         i was thinking that the domain or globalnames parameters might be
         diff on A
         & B ,
         but they are absolutely same .

         any suggestions are most welcome ...

         thanks in advance
         ratnesh





         -----------------------------------------------

         Ratnesh Kumar Singh
         Sr. Software Engineer
         Patni Computer Systems Ltd
         TTC Mahape , Navi Mumbai
         Work : (91 22) 7611090/110/128/350 Ext. 2107
         Home : (91 22) 8662162
         http://www.patni.com <http://www.patni.com>
         World-Wide Partnerships. World-Class Solutions.


         -----------------------------------------------


         --
         Please see the official ORACLE-L FAQ: http://www.orafaq.com <
         http://www.orafaq.com>
         --
         Author: Ratnesh Kumar Singh
           INET: ratnesh.singh_at_patni.com <mailto:ratnesh.singh_at_patni.com>

         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 <mailto: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: 
  INET: Shreepad.Vaidya_at_alltel.com

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).