Re: Query on DB Link creation
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 10 Aug 2011 10:02:38 -0700 (PDT)
Message-ID: <5697af74-746b-4caa-80db-010d3c46a9d9_at_j15g2000yqf.googlegroups.com>
On Aug 9, 1:56 am, Arun <set..._at_gmail.com> 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
Date: Wed, 10 Aug 2011 10:02:38 -0700 (PDT)
Message-ID: <5697af74-746b-4caa-80db-010d3c46a9d9_at_j15g2000yqf.googlegroups.com>
On Aug 9, 1:56 am, Arun <set..._at_gmail.com> 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
Database links are for accessing remote Oracle instances. Why not define a synonym for each user B object that user A uses then when user B is reloaced to a new instance just update the synonym to refer to the remote version of the table? Create [public] synonym tableA for userB.tableA_at_remote_db
HTH -- Mark D Powell -- Received on Wed Aug 10 2011 - 12:02:38 CDT