Database Link Notes
While accessing remote tables from an Autonomous AI Database instance using a DBLink, you can query the following.
-
ALL_REMOTE_TABLESto retrieve information about tables in remote databases -
ALL_REMOTE_VIEWSto retrieve information about views in remote databases
READ privilege on these views are granted to the ADMIN user
WITH GRANT OPTION and to the PDB_DBA role without
GRANT OPTION.
Parent topic: Use Database Links with Autonomous AI Database