Oracle | OWM_DDL

Oracle OWM_DDL_PKG Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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