Oracle OWM_DDL_PKG
Version 18.3

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_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
LTAQ
LTDTRG
OWM_ASSERT
OWM_CPKG_PKG
OWM_IEXP_PKG
What's New In 18c
What's New In 19c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx