Oracle OWM_DDL_PKG
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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_MIG_PKG
ALL_NESTED_TABLES DBA_TYPE_ATTRS OWM_MP_PKG
ALL_USERS DBA_UNUSED_COL_TABS OWM_VSCRIPT_PKG
CCOL$ DBA_VIEWS PLITBLM
CDEF$ DBMS_LOCK UD_TRIGS
COL$ DUAL WM$COLUMN_PROPS
CON$ KU$_DDL WM$CONSTRAINTS_TABLE
DBA_COL_PRIVS KU$_DDLS WM$CONS_COLUMNS
DBA_CONSTRAINTS LT WM$DBA_TAB_COLS
DBA_CONS_COLUMNS LTADM WM$NESTED_COLUMNS_TABLE
DBA_INDEXES LTDDL WM$RIC_TABLE
DBA_IND_COLUMNS LTDTRG WM$UDTRIG_DISPATCH_PROCS
DBA_IND_EXPRESSIONS LTRIC WM$UDTRIG_INFO
DBA_JOIN_IND_COLUMNS LTUTIL WM$VERSIONED_TABLES
DBA_NESTED_TABLES LT_CTX_PKG WM$VERSIONED_TABLES$H
DBA_TABLES LT_EXPORT_PKG WM_DDL_UTIL
DBA_TABLESPACES OBJ$ WM_ERROR
DBA_TAB_COLS OWM_ASSERT_PKG  
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.0.1
Security Model Owned by WMSYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/owmcddls.plb
Subprograms
 
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');

Related Topics
Built-in Functions
Built-in Packages
DBMS_WM
What's New In 12cR2
What's New In 18cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved