Re: DB links

From: Ana Choto <achoto_at_american.edu>
Date: Thu, 12 Feb 2004 10:51:43 -0500
Message-ID: <OF78C1DC6F.BE2DE0A7-ON85256E38.00567E6C-85256E38.00572653@american.edu>

I'm not sure if you found a solution for this yet. But, one thing I had trouble with when using a link was that I was using the service name on my select statement instead of the name of the link's.

i.e., select from xxx_at_servicename instead of select from xxx_at_dblink_name

Thanks

Ana E. Choto
American University
e-Operations - Information Technology
Phone (202) 885-2275
Fax (202) 885-2224

                                                                           
             Michael Milligan                                              
             <Michael.Milligan                                             
             @ingenix.com>                                              To 
             Sent by:                  "'oracle-l_at_freelists.org'"          
             oracle-l-bounce_at_f         <oracle-l_at_freelists.org>            
             reelists.org                                               cc 
                                                                           
                                                                   Subject 
             02/11/2004 06:50          DB links                            
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             oracle-l_at_freelist                                             
                   s.org

Has anyone had trouble using a link created for just certain databases, when
everything is set right. In other words, no reason can be seen why it wouldn't work? We changed the global name, etc., etc. I can connect to the database but when I create the link, then try to select from dual from another database, it says "TNSNames cannot resolve service name". But using the same service name, I immediately connect successfully to the database!

Driving us crazy. Any help would be greatly appreciated.

Thanks,

Mike

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Feb 12 2004 - 09:51:43 CST