Infrastruktur & Datenbanktechnologie30.03.2023Tom Lieber
The end of the Oracle-DB - Links?
Database links in Autonomous Database Shared are the past –
Cloud links are the future
— HERMANN BAER – ORACLE PRODUCT MANAGEMENT
Database links have been a popular way to let remote databases access
specific tables or views in a database, but they require a lot of back and
forth communication to establish the connection. However, with Oracle
Autonomous Database Shared’s new feature, Cloud Links, data owners
can easily register a table or view for remote access by a certain
audience, without needing to set up a connection every time someone
needs to access the data. This means that anyone with remote access
can discover and use the data that has been made available to them
without any extra hassle.
select .. from <namespace>.<name>@cloud$link;