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 is now availble. If you haven't you downloaded already: Why?

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