Oracle | OWM_DDL

Oracle OWM_DDL_PKG 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 Utility supporting Oracle Workspace Manager version enabled tables.

AUTHID DEFINER

Dependencies

ALL_COL_PRIVS	LTDEFINER
ALL_CONSTRAINTS	LTDTRG
ALL_CONS_COLUMNS	LTRIC
ALL_INDEXES	LTUTIL
ALL_IND_COLUMNS	LT_CTX_PKG
ALL_IND_EXPRESSIONS	LT_EXPORT_PKG
ALL_JOIN_IND_COLUMNS	OWM_ASSERT_PKG
ALL_LOG_GROUPS	OWM_BULK_LOAD_PKG
ALL_LOG_GROUP_COLUMNS	OWM_DYNSQL_ACCESS
ALL_NESTED_TABLES	OWM_MIG_PKG
ALL_TABLES	OWM_MP_PKG
ALL_TAB_COLS	OWM_VSCRIPT_PKG
ALL_TAB_PRIVS	PLITBLM
ALL_TRIGGERS	UD_TRIGS
ALL_UNUSED_COL_TABS	WM$COLUMN_PROPS_USER
ALL_VIEWS	WM$CONSTRAINTS_TABLE
DBA_COL_PRIVS	WM$CONS_COLUMNS_USER
DBA_TAB_PRIVS	WM$DBA_TAB_COLS
DBMS_LOCK	WM$NESTED_COLUMNS_TABLE_USER
DUAL	WM$RIC_TABLE_USER
KU$_DDL	WM$UDTRIG_DISPATCH_PROCS_USER
KU$_DDLS	WM$UDTRIG_INFO_USER
LT	WM$VERSIONED_TABLES_USER
LTADM	WM_DDL_UTIL
LTDDL	WM_ERROR

Documented No

Exceptions

Error Code	Reason
ORA-20132	table '<schema_name>.<table_name>' is not version enabled
ORA-20337	This table can only be dropped by dbms_wm.rollbackDDL/commitDDL

First Available 12.1

Security Model Owned by WMSYS with no privileges granted.

Access to some subpograms prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmcddls.plb

Subprograms

BEGINDDL	DROPVIEWS	RECREATEINSTOFTRIGS
COMMITDDL	GETORIGINALDDL	RECREATEVIEWS
COMPAREINDEXPROPERTIES	GETUCDETAILS	ROLLBACKDDL
CREATERICVIEWS	HAVEIDENTICALCOLUMNS

BEGINDDL

Undocumented owm_ddl_pkg.beginDDL( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2);

BEGIN

        wmsys.owm_ddl_pkg.beginDDL('SCOTT', 'EMP');

      END;

      /

      *

      ORA-20132: table 'SCOTT.EMP' is not version enabled

      

      BEGIN

        dbms_wm.EnableVersioning('SCOTT.EMP');

      END;

      /

      

      PL/SQL procedure successfully completed.

      

      BEGIN

        wmsys.owm_ddl_pkg.beginDDL('SCOTT', 'EMP');

      END;

      /

      *

      ORA-04088: error during execution of trigger 'WMSYS.NO_VM_DDL'

COMMITDDL

Undocumented owm_ddl_pkg.commitDDL( table_owner_var IN VARCHAR2, table_naem_var IN VARCHAR2, ignore_last_erorr IN BOOLEAN, enforce_unique_constraints IN BOOLEAN, enforce_rics IN BOOLEAN);

exec owm_ddl_pkg.commitDDL('SCOTT', 'EMP', TRUE, TRUE, TRUE);

COMPAREINDEXPROPERTIES

Undocumented owm_ddl_pkg.compareIndexProperties( cons_owner_var IN VARCHAR2, cons_name_var IN VARCHAR2, cons_type_var IN VARCHAR2, table_name_var IN VARCHAR2, ve_index_owner IN VARCHAR2, ve_index_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CREATERICVIEWS

Undocumented owm_ddl_pkg.createRICViews( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2);

exec owm_ddl_pkg.createRICViews('SCOTT', 'EMP');

DROPVIEWS

Undocumented owm_ddl_pkg.dropViews( table_owner_v IN VARCHAR2, table_name_v IN VARCHAR2, dgdrop IN BOOLEAN, old_version IN VARCHAR2);

TBD

GETORIGINALDDL

Undocumented owm_ddl_pkg.getOriginalDDL( table_owner IN VARCHAR2, table_name IN VARCHAR2, ddl_stmts IN OUT ku$_ddls;

DECLARE

       retTab ku$_ddls;

      BEGIN

        wmsys.owm_ddl_pkg.getOriginalDDL('SCOTT', 'EMP', retTab);

      END;

      /

GETUCDETAILS

Undocumented owm_ddl_pkg.getUCDetails( index_owner_var IN VARCHAR2, index_name_var IN VARCHAR2, table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2) RETURN VARCHAR2;

exec owm_ddl_pkg.getUCDetails('SCOTT', 'AUX_EMP', 'SCOTT', 'EMP_AUX');

HAVEIDENTICALCOLUMNS

Undocumented owm_ddl_pkg.haveIdenticalColumns( index_owner_var IN VARCHAR2, skc_index_name IN VARCHAR2, diev_index_name IN VARCHAR2);

TBD

RECREATEINSTOFTRIGS

Undocumented owm_ddl_pkg.recreateInstOfTrigs( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, buffer_code IN BOOLEAN, recreatecttrigs IN NUMBER);

TBD

RECREATEVIEWS

Undocumented owm_ddl_pkg.recreateViews( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, buffercode IN BOOLEAN);

exec owm_ddl_pkg.recreateViews('SCOTT', 'EMP', TRUE);

ROLLBACKDDL

Undocumented owm_ddl_pkg.rollbackDDL( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2);

exec owm_ddl_pkg.rollbackDDL('SCOTT', 'EMP');