Is there any other way to query two databases with Oracle SQL Developer without creating a database link

Question

I'm trying to code a query that needs to access two separate database connections and cant figure out how. I have my .sql file connected to connection: A, but i need to join information from connection: b to get all the information I need. I cant create a database link, which is the answer i'm seeing everywhere. The query will look something like this:

SELECT 
    a.ROW_ID,
    a.ATTRIB_1,
    b.Date2
From A.user.info a, B.super.info b
Where a.stat1 = b.stat1;

Sebas · Accepted Answer · 2013-03-13 15:46:06Z

1

There's nothing else you can do than creating that link, to go simply.

The question is why can't you?

In a company I worked for they also had a (to me: weird) politic about that, and didn't want dblinks (anymore).

They opted for MQ queues from IBM as a substitute.

Hope it helped.

answered Mar 13, 2013 at 15:46

Sebas

21.6k9 gold badges60 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there any other way to query two databases with Oracle SQL Developer without creating a database link

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related