Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_DBLINK Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Creates or drop database links between 2 different Autonomous Databases.

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_CLOUD_DBLINK_INTERNAL	DBMS_UTILITY
DBMS_CLOUD_ADMIN	DBMS_STANDARD

Documented No

First Available 23ai

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbms_cloud_dblink.sql
{ORACLE_HOME}/rdbms/admin/prvt_cloud_dblink_body.plb

Subprograms

CREATE_DATABASE_LINK

DROP_DATABASE_LINK

CREATE_DATABASE_LINK (new 23ai)

Undocumented dbms_cloud_dblink.create_database_link( db_link_name IN VARCHAR2, hostname IN VARCHAR2, port IN NUMBER, service_name IN VARCHAR2, ssl_server_cert_dn IN VARCHAR2, credential_name IN VARCHAR2, directory_name IN VARCHAR2, gateway_link IN BOOLEAN DEFAULT FALSE, public_link IN BOOLEAN DEFAULT FALSE);

TBD

DROP_DATABASE_LINK (new 23ai)

Undocumented dbms_cloud_dblink.drop_database_link( db_link_name IN VARCHAR2, public_link IN BOOLEAN);

TBD