Oracle | OWM_DDL

Oracle OWM_DDL_PKG Version 21c

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

AUTHID DEFINER

Dependencies

ALL_LOG_GROUPS	DBA_TAB_PRIVS	OWM_BULK_LOAD_PKG
ALL_LOG_GROUP_COLUMNS	DBA_TRIGGERS	OWM_DYNSQL_ACCESS
ALL_NESTED_TABLES	DBA_TYPE_ATTRS	OWM_MIG_PKG
ALL_USERS	DBA_UNUSED_COL_TABS	OWM_MP_PKG
CCOL$	DBA_VIEWS	OWM_VSCRIPT_PKG
CDEF$	DBMS_LOCK	PLITBLM
COL$	DUAL	UD_TRIGS
CON$	KU$_DDL	WM$COLUMN_PROPS
DBA_COL_PRIVS	KU$_DDLS	WM$CONSTRAINTS_TABLE
DBA_CONSTRAINTS	LT	WM$CONS_COLUMNS
DBA_CONS_COLUMNS	LTADM	WM$DBA_TAB_COLS
DBA_INDEXES	LTDDL	WM$NESTED_COLUMNS_TABLE
DBA_IND_COLUMNS	LTDTRG	WM$RIC_TABLE
DBA_IND_EXPRESSIONS	LTRIC	WM$UDTRIG_DISPATCH_PROCS
DBA_JOIN_IND_COLUMNS	LTUTIL	WM$UDTRIG_INFO
DBA_NESTED_TABLES	LT_CTX_PKG	WM$VERSIONED_TABLES
DBA_TABLES	LT_EXPORT_PKG	WM$VERSIONED_TABLES$H
DBA_TABLESPACES	OBJ$	WM_DDL_UTIL
DBA_TAB_COLS	OWM_ASSERT_PKG	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.

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;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "WMSYS.OWM_DDL_PKG", line 3918

      ORA-06512: at "WMSYS.WM_ERROR", line 449

      ORA-06512: at "WMSYS.WM_ERROR", line 463

      ORA-06512: at "WMSYS.OWM_DDL_PKG", line 3812

      ORA-06512: at line 4

      

      SQL> BEGIN

      2 dbms_wm.EnableVersioning('SCOTT.EMP');

      3 END;

      4 /

      

      PL/SQL procedure successfully completed.

      

      SQL> BEGIN

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

        3  END;

        4  /

      BEGIN

      *

      ERROR at line 1:

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

      ORA-06512: at "WMSYS.OWM_DDL_PKG", line 2351

      ORA-06512: at "WMSYS.OWM_DDL_PKG", line 2295

      ORA-00604: error occurred at recursive SQL level 2

      ORA-20337: This table can only be dropped by dbms_wm.rollbackDDL/commitDDL

      ORA-06512: at "WMSYS.LTADM", line 9803

      ORA-06512: at "WMSYS.WM_ERROR", line 449

      ORA-06512: at "WMSYS.WM_ERROR", line 456

      ORA-06512: at "WMSYS.LTADM", line 9692

      ORA-06512: at line 17

      ORA-06512: at "WMSYS.OWM_DDL_PKG", line 2292

      ORA-06512: at line 2

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;

SQL> DECLARE

        2   retTab ku$_ddls;

        3  BEGIN

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

        5  END;

        6  /

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');