Database Link Notes

While accessing remote tables from an Autonomous AI Database instance using a DBLink, you can query the following.

• ALL_REMOTE_TABLES to retrieve information about tables in remote databases, including tables accessible through Database Links and Cloud Links.

• ALL_REMOTE_VIEWS to retrieve information about views in remote databases. The READ privilege on these views are granted to the ADMIN user WITH GRANT OPTION and to the PDB_DBA role without GRANT OPTION.