Create Database Links from Other Databases to Autonomous Database
You can create database links to an Autonomous Database from an Oracle database that is not an Autonomous Database. For example from an on-premise Oracle database to an Autonomous Database
-
Supported Oracle Database versions for database links where the source is an Oracle Database and the target is an Autonomous Database instance are: 19.2 (or later), 21 (base release or later).
-
If you are using database links between Autonomous Database and other Oracle Databases, you might need to apply Patch 33843368 on the Oracle Database that is not an Autonomous Database. This applies to cases where the Autonomous Database instance is either the source or the target of the database link.
See My Oracle Support Knowledge Base: Patch Requirement For Database Links Between ADB-S And Other Oracle Databases(Doc ID 2874244.1) for further details.
To create database links to an Autonomous Database do the following:
To list the database links, use the ALL_DB_LINKS
view. See
ALL_DB_LINKS for more information.
For additional information, see:
-
See CREATE DATABASE LINK for details on the procedure.
Parent topic: Use Database Links with Autonomous Database