Re: DB links
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 12 Feb 2004 12:22:30 -0500
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@servicename instead of select from
> xxx@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@xxxxxxxxxxxxx'"
>
> oracle-l-bounce@f <oracle-l@xxxxxxxxxxxxx>
>
> reelists.org
> cc
>
>
>
> Subject
> 02/11/2004 06:50 DB links
>
> PM
>
>
>
>
>
> Please respond to
>
> oracle-l@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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
