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;

https://blogs.oracle.com/datawarehousing/post/database-links-in-autonomous-database-shared-are-the-past—cloud-links-are-the-future

We like this Solution

SPHINX.AT