Query on DB Link creation

From: Arun <setsun_at_gmail.com>
Date: Mon, 8 Aug 2011 22:56:39 -0700 (PDT)
Message-ID: <6cd75164-a633-4458-b47a-8cb365b23b51_at_y16g2000yqk.googlegroups.com>

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.

Arun Received on Tue Aug 09 2011 - 00:56:39 CDT

Original text of this message