Database Link Notes with a Target that is an Autonomous AI Database

Provides notes for creating database links to a target that is another Autonomous AI Database.

Notes for database links to another Autonomous AI Database:

• Only one wallet file is valid per directory for use with database links. You can only upload one cwallet.sso at a time to the directory you choose for wallet files (for example DBLINK_WALLET_DIR). This means with a cwallet.sso in DBLINK_WALLET_DIR you can only create database links to the databases for which the wallet in that directory is valid. To use multiple cwallet.sso files with database links you need to create additional directories and put each cwallet.sso in a different directory. When you create database links with DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK, specify the directory that contains the wallet with the directory_name parameter.

  See Create Directory in Autonomous AI Database for information on creating directories.

• To list the database links, use the ALL_DB_LINKS view. See ALL_DB_LINKS for more information.

• 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

  • 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.

• The wallet file, along with the Database user ID and password provide access to data in the target Autonomous AI Database. Store wallet files in a secure location. Share wallet files only with authorized users.

• When private_target => TRUE, creating cross-realm database links, where the source database and the target database are in different Oracle Cloud Infrastructure realms, is not supported.