Search code examples
oracledblinktns

How to select a table between a TNS connection and a Direct one?

I'm new in this forum, but I've seen a lot of inputs from different collaborators, & I would like to ask the following:

I've two databases (Oracle):

a) One with TNS names: [email protected].
A query into this one would be, for example (this works):

SELECT * FROM [email protected];

b) The other has a direct connection (Host, Port & Service_Name): [email protected]:Port/Service_Name

I'm trying basically the same thing:

SELECT * FROM [email protected]:Port/Service_Name

I'm not sure how I can connect to the second database from the first. So far I've been unsuccessful.

Solution

  • you can create a link with the connection specification and use that link