Oracle Cross database queries: you need a “database link” for that
Posted by jpluimers on 2016/09/27
I recently learned that you can do cross database queries in Oracle using database links.
You need to prefix your objects with the right schema/owner (for instance dbo.) and suffix with an @ sign followed by the database link name.
This query finds all configured database links:
select * from all_db_links;
–jeroen
via: Ask Tom “database link”.
The Wiert Corner - irregular stream of stuff 
Leave a Reply