1

I have two connections in SQL developer that one of them is SQL server (A) and the other one is oracle (B). how can I make a database link between this two connections from (B) to (A) to select connection A data from connection B?

3
  • It really has nothing to do with 'connections', as defined in SQL Dev. That is just a construct within SQL Dev to define how it connects to a particular database. SQL Dev is just a client to any one database. While you can have SQL Dev connections concurrently open to multiple databases, those connections have no more to do with each other than two separate invocations of sqlplus, each connected to a different db. If you want to access an oracle db from an MSSQL db, you create a 'shared server' in the MSSQL. If you want to go the other way, create a DB Link in the oracle DB.
    – EdStevens
    Jun 18, 2018 at 14:48
  • HIt the space limit in my previous response. In order to better understand the concepts, you might find this blog article ineresting: edstevensdba.com/oracle-heterogeneous-communication/…. And remember, this is not a SQL Developer question.
    – EdStevens
    Jun 18, 2018 at 14:50
  • @EdStevens - hitting your limit on a comment is a good indication that you are writing an Answer, not a Comment. Jun 18, 2018 at 16:57

1 Answer 1

1

The last time I looked (and that's quite a number of years ago), you needed Oracle Gateway to establish such a link.

Just checked, the product is still around: Oracle Database Gateway for SQL Server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.