Oracle | DBMS_GSM

Oracle DBMS_GSM_DDL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented Global Service Manager Administration Utilities.

The installation file contains the following note: "since changes to gsmadmin_internal tables aren't propagated to logical standbys, mark all gsm packages as unsupported"

AUTHID DEFINER

Dependencies

DBMS_GSM_DDL_LIB	DBMS_LOB	SHARD_KEYS
DBMS_GSM_SEC	DDL_REQUESTS_PWD	UTL_RAW
DBMS_GSM_SEC_LIB

Documented No

First Available 20c

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to the GSMADMIN_ROLE and GSMCATUSER roles.

Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfix.sql
{ORACLE_HOME}/rdbms/admin/prvtgwmfix.plb

Subprograms

DECDDL

DECDDLVCH

DECDDL

Undocumented dbms_gsm_ddl.decDDL( key_id IN NUMBER DEFAULT NULL, ddl_text IN BLOB, ddlid IN NUMBER DEFAULT NULL) RETURN CLOB;

TBD

DECDDLVCH (new 23ai trim_size default)

Undocumented dbms_gsm_ddl.decDDLVch( key_id IN NUMBER DEFAULT NULL, ddl_text IN CLOB DEFAULT NULL, enc_ddl IN BLOB DEFAULT NULL, ddlid IN NUMBER DEFAULT NULL, trim_size IN NUMBER DEFAULT 8191) RETURN VARCHAR2;

TBD