Re: Can you create a database link back to same database instance?

From: Romeo Ybanez <raybanez_at_yahoo.com>
Date: Tue, 10 Mar 2009 23:40:40 -0700 (PDT)
Message-ID: <435054.90389.qm_at_web56904.mail.re3.yahoo.com>

Hi,

I have two instances in one box. One instance has a public database link directed towards a schema in the same instance. The other instance also has a public database link directed towards a schema in its own instance. I don't think this is allowed because the solution here is to grant insert, select, update or delete privileges. But I was wondering why one of the instances successfully implements a database link while the other does not.

So my question is: Is it possible to create a public database link pointed to a schema in the same instance where the database link is created? If not, why in the other instance above it works. What could have been the trick?

Thank you.

Romy

---

From: Jared Still <jkstill_at_gmail.com> To: raybanez_at_yahoo.com
Cc: oracle-l_at_freelists.org
Sent: Wednesday, March 11, 2009 12:12:28 AM Subject: Re: Can you create a database link back to same database instance?

On Tue, Mar 10, 2009 at 3:13 AM, Romeo Ybanez <raybanez_at_yahoo.com> wrote:

So it seems that you can create a database link back to the same database instance. If not I wonder what the trick by the other db?

Not enough information.

Please review: http://www.catb.org/~esr/faqs/smart-questions.html

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist       

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 11 2009 - 01:40:40 CDT