| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB links
Ana, you have been using db links all the time, but when you are
running LDAP or Oracle*Names, and your databases have GLOBAL_NAMES
set to true. then you have db link created for each service name,
exactly as if
CREATE DATABASE ORA.WORLD LINK USING 'ORA.WORLD'; was ran. In addition to that, databe slink can contain username, so that you don't have to have identical passwords on all databases but are free to use DBMS_RANDOM for password generation.
or
On 02/12/2004 10:51:43 AM, Ana Choto wrote:
>
>
>
>
> 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
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Feb 12 2004 - 11:22:30 CST
 |
 |