Re: Query on DB Link creation

From: Mladen Gogala <>
Date: Tue, 9 Aug 2011 14:34:52 +0000 (UTC)
Message-ID: <>

On Mon, 08 Aug 2011 22:56:39 -0700, Arun wrote:

> Hi Guys,
> I need some help in creating DB Links.
> 1. While I read the documentation for DB link creation, I found that
> TNSNAMES.ora entry of the target DB is essential to create the DB link (
> in USING clause of the DB link syntax
> Incidentally, my organization uses LDAP to resolve/identify the
> database. In this situation, how can i create the DB linkin
> 2. I need to create DB link object on schema A to connect to schema B.
> Both schema A and B are on the same instance.
> Something like
> create database link link_from_a_2_b
> connect to b identified by bpass
> using <i dont know what should be given here as said in #1 >
> The question I have is : Can a DB link of this sort be created?
> I understand that referencing objects in B from A this way is not a
> ideal method since we can grant permissions to A to access objects in B.
> However, there is a possiblity that B might be moved to a new instance
> in future. So if I create a DB link, movement of B across different
> instance would be much quicker.
> Thanks in advance for your assistance in this regard.
> Cheers
> Arun

If ever RTFM was an appropriate answer, it's in this case. Do you have a DBA in your organization? Please, ask him to tell you about the facts of life, birds, bees, LDAP and DB links.

Received on Tue Aug 09 2011 - 09:34:52 CDT

Original text of this message