Oracle | DBMS_GSM

Oracle DBMS_GSM_DDL Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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 23c 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