Oracle WM_DDL_UTIL
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 Workspace Management Supporting Utilities
AUTHID DEFINER
Dependencies
ALL_COLL_TYPES DBA_NESTED_TABLES OBJ$
ALL_CONSTRAINTS DBA_OBJECTS OWM_ASSERT_PKG
ALL_CONS_COLUMNS DBA_PART_INDEXES OWM_DDL_PKG
ALL_NESTED_TABLES DBA_PART_TABLES OWM_DYNSQL_ACCESS
ALL_OBJECTS DBA_TABLES OWM_IEXP_PKG
ALL_TYPE_ATTRS DBA_TAB_COLS OWM_MIG_PKG
ALL_USERS DBA_TAB_PRIVS OWM_VSCRIPT_PKG
CDEF$ DBA_TRIGGERS PLITBLM
COL$ DBMS_LOB TRIGGER$
COLTYPE$ DBMS_LOCK WM$COLUMN_PROPS
CON$ DBMS_STANDARD WM$CONSTRAINTS_TABLE
DBA_ALL_TABLES DUAL WM$CONS_COLUMNS
DBA_COL_PRIVS IND$ WM$DBA_TAB_COLS
DBA_CONSTRAINTS LT WM$NESTED_COLUMNS_TABLE
DBA_CONS_COLUMNS LTADM WM$RIC_TABLE
DBA_INDEXES LTDDL WM$RIC_TRIGGERS_TABLE
DBA_IND_COLUMNS LTDTRG WM$UDTRIG_INFO
DBA_IND_EXPRESSIONS LTRIC WM$VERSIONED_TABLES
DBA_IND_PARTITIONS LTUTIL WM_ERROR
DBA_IND_SUBPARTITIONS LT_CTX_PKG WM_PERIOD
Documented No
First Available Not known
Security Model Owned by WMSYS with no privileges granted.

Direct access to this package is prevented by means of an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/owmdutls.plb
{ORACLE_HOME}/rdbms/admin/owmdutlb.plb
Subprograms
 
ADDCOLUMNS
Undocumented wm_ddl_util.addColumns(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist        IN VARCHAR2,
vt_option   IN NUMBER,
vtrange     IN wmsys.wm_period
undo_space  IN VARCHAR2);
TBD
 
ADDUSERCOLUMNS
Undocumented wm_ddl_util.addUserColumns(
schema     IN     VARCHAR2,
table_name IN     VARCHAR2,
colstr     IN OUT VARCHAR2,
hist       IN     VARCHAR2,
vt_option  IN     NUMBER);
TBD
 
ADDVALIDTIMESUPPORT
Undocumented wm_ddl_util.addValidTimeSupport(
table_owner_v     IN VARCHAR2,
table_name_v      IN VARCHAR2,
vtrange           IN wmsys.wm_period,
ignore_last_error IN BOOLEAN);
TBD
 
AVTDDL
Undocumented wm_ddl_util.avtDDL(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
state             IN VARCHAR2,
ddlstmt           IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
BASEVIEW_COMMON
Undocumented wm_ddl_util.baseView_common(
table_owner_v   IN VARCHAR2,
table_name_v    IN VARCHAR2,
tab_view_name_v IN VARCHAR2,
vtid            IN NUMBER,
hist            IN VARCHAR2,
extension_v     IN VARCHAR2,
pk_keycols      IN VARCHAR2,
vt_option       IN NUMBER)
RETURN VARCHAR2;
TBD
 
CARRYFORWARDPRIVSQL
Undocumented wm_ddl_util.carryForwardPrivSQL(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vt_option   IN NUMBER);
TBD
 
CHECKFORERRORSEV
Undocumented wm_ddl_util.checkForErrorSev(
schema     IN VARCHAR2,
tab_name   IN VARCHAR2,
hist       IN VARCHAR2,
vt_option  IN NUMBER,
commit_ddl IN BOOLEAN);
TBD
 
CHECK_MRIC_CASCADE
Undocumented wm_ddl_util.check_mric_cascade(
owner_name IN VARCHAR2,
table_name IN VARCHAR2);
TBD
 
CONFVIEW_COMMON
Undocumented wm_ddl_util.confView_common(which IN VARCHAR2) RETURN VARCHAR2;
TBD
 
CREATEAUXILIARYTABLE
Undocumented wm_ddl_util.createAuxiliaryTable(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vt_option   IN NUMBER,
evoperation IN BOOLEAN,
maintabts_v IN VARCHAR2,
mainidxts_v IN VARCHAR2);
TBD
 
CREATEBASEVIEW
Undocumented wm_ddl_util.createBaseView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
hist        IN VARCHAR2,
vt_option   IN NUMBER,
pk_keycols  IN VARCHAR2,
colstr_v    IN VARCHAR2,
vappend_v   IN VARCHAR2,
tappend_v   IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATECONFLICTVIEW
Undocumented wm_ddl_util.createConflictView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
vt_option   IN NUMBER,
colstr_v    IN VARCHAR2,
keycols_v   IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATECONSVIEW
Undocumented wm_ddl_util.createConsView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
vt_option   IN NUMBER,
colstr      IN VARCHAR2,
pk_cols     IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATEDIFFVIEW
Undocumented wm_ddl_util.createDiffView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
vt_option   IN NUMBER,
colstr_v    IN VARCHAR2,
keycols_v   IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATEHISTORYVIEW
Undocumented wm_ddl_util.createHistoryView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
hist        IN VARCHAR2,
vt_option   IN NUMBER,
pk_keycols  IN VARCHAR2,
colstr_v    IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATELCKTABLE
Undocumented wm_ddl_util.createLckTable(
owner_name_var IN VARCHAR2,
table_name_var IN VARCHAR2);
TBD
 
CREATELOCKVIEW
Undocumented wm_ddl_util.createLockView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
colstr_v    IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATEMWVIEW
Undocumented wm_ddl_util.createMWView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
colstr_v    IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATENESTEDTABLEBASEVIEW
Undocumented wm_ddl_util.createNestedTableBaseView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist        IN VARCHAR2,
parent_keys IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATENESTEDTABLECONSVIEW
Undocumented wm_ddl_util.createNestedTableConsView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist        IN VARCHAR2,
parent_keys IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATETEMPTABLE
Undocumented wm_ddl_util.createTempTable(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid_v      IN NUMBER,
pkey_cols_v IN VARCHAR2);
TBD
 
CREATETEMPTOPVIEW
Undocumented wm_ddl_util.createTempTopView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
colstr_v    IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATETOPVIEW
Undocumented wm_ddl_util.createTopView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
hist        IN VARCHAR2,
vt_option   IN NUMBER,
colstr_v    IN VARCHAR2,
evoperation IN BOOLEAN);
TBD
 
CREATEUNIONBASEVIEW
Undocumented wm_ddl_util.createUnionBaseView(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
hist        IN VARCHAR2,
pk_keycols  IN VARCHAR2,
colstr_v    IN VARCHAR2,
evoperation IN BOOLEAN,
genricviews IN BOOLEAN);
TBD
 
CREATEUSERVIEWS
Undocumented wm_ddl_util.createUserViews(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
hist        IN VARCHAR2,
colstr_v    IN VARCHAR2,
evoperation IN BOOLEAN,
buffer_code IN BOOLEAN);
TBD
 
CREATEVTTABLE
Undocumented wm_ddl_util.creaateVTTable(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist        IN VARCHAR2,
evoperation IN BOOLEAN,
maintabts_v IN VARCHAR2,
mainidxts_v IN VARCHAR2);
TBD
 
DELETENONLATESTDATAFROMLIVE
Undocumented wm_ddl_util.deleteNonLatestDataFromLive(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vt_option   IN NUMBER,
keepwmvalid IN BOOLEAN);
TBD
 
DELETENONLIVEDATA
Undocumented wm_ddl_util.deleteNonLiveData(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vt_option   IN NUMBER,
force_v     IN BOOLEAN,
undo_space  IN VARCHAR2);
TBD
 
DIFFVIEW_COMMON
Undocumented wm_ddl_util.diffView_common(which IN VARCHAR2) RETURN VARCHAR2;
TBD
 
DROPCONFLICTSRELATED
Undocumented wm_ddl_util.dropConflictsRelated(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
dgoperation IN BOOLEAN);
TBD
 
DROPDIFFRELATED
Undocumented wm_ddl_util.dropDiffRelated(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
dgoperation IN BOOLEAN);
TBD
 
DROPWMCOLUMNS
Undocumented wm_ddl_util.dropWMColumns(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist_option IN VARCHAR2,
vt_option   IN NUMBER,
keepwmvalid IN BOOLEAN);
TBD
 
FIXCONSTRAINTSEV
Undocumented wm_ddl_util.fixconstraintsEV(
tab_owner_v IN     VARCHAR2,
tab_name_v  IN     VARCHAR2,
pk_keycols  IN OUT VARCHAR2,
hist        IN     VARCHAR2,
vt_option   IN     NUMBER);
TBD
 
FIXINDEXEV
Undocumented wm_ddl_util.fixIndexEV(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist        IN VARCHAR2,
mainidxts_v IN VARCHAR2);
TBD
 
FIXPRIVSEV
Undocumented wm_ddl_util.fixPrivsEV(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
hist        IN VARCHAR2,
vt_option   IN NUMBER);
TBD
 
GETASSOCIATEDINDEX
Undocumented wm_ddl_util.getAssociatedIndex(
owner_var           IN  VARCHAR2,
constraint_name_var IN  VARCHAR2,
table_name_var      IN  VARCHAR2,
index_owner_var     OUT VARCHAR2,
index_name_var      OUT VARCHAR2,
disabled_index      IN  BOOLEAN);
TBD
 
GETCOLSTREV
Undocumented wm_ddl_util.getColstrEV(
tab_owner IN  VARCHAR2,
tab_name  IN  VARCHAR2,
colstr    OUT VARCHAR2);
TBD
 
GETINDEXCLAUSE
Undocumented wm_ddl_util.getIndexClause(
index_owner_v IN VARCHAR2,
index_name_v  IN VARCHAR2,
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
uniqueness    IN BOOLEAN,
include_meta  IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETINDEXCOLUMNS
Undocumented wm_ddl_util.getIndexColumns(
index_owner_var IN VARCHAR2,
index_name_var  IN VARCHAR2,
append_desc_var IN BOOLEAN,
include_meta    IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETINDEXSUBCLAUSE
Undocumented wm_ddl_util.getIndexSubClause(
index_owner_var IN VARCHAR2,
index_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GRANTWMSYSPRIVS
Undocumented wm_ddl_util.grantWMSysPrivs(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vt_option   IN NUMBER,
evoperation IN BOOLEAN,
buffer_code IN BOOLEAN);
TBD
 
INDEXCREATEDBYCONSTRAINT
Undocumented wm_ddl_util.indexCreatedByConstraint(
index_owner_var IN VARCHAR2,
index_name_var  IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF wmsys.wm_ddl_util.indexCreatedByConstraint('UWCLASS', 'PK_AIRPLANES') THEN
    dbms_output.put_line('Index Created By A Constraint');
  ELSE
    dbms_output.put_line('Index Not Created By A Constraint');
  END IF;
END;
/
IF wmsys.wm_ddl_util.indexCreatedByConstraint('UWCLASS', 'PK_AIRPLANES') THEN
*
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00904: insufficient privilege to access object WM_DDL_UTIL
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
 
IS_RIC_CHILD_OF_ENABLED_TABLE
Undocumented wm_ddl_util.is_ric_child_of_enabled_table(
tab_owner IN VARCHAR2,
tab_name  IN VARCHAR2);
TBD
 
IS_RIC_PARENT
Undocumented wm_ddl_util.is_ric_parent(
tab_owner IN VARCHAR2,
tab_name  IN VARCHAR2);
TBD
 
MODIFYNESTEDCOLUMNSDV
Undocumented wm_ddl_util.modifyNestedColumnsDV(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2);
TBD
 
MODIFYNESTEDCOLUMNSEV
Undocumented wm_ddl_util.modifyNestedColumnsEV(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist        IN VARCHAR2);
TBD
 
MODIFYNESTEDCOLUMNS_DDL
Undocumented wm_ddl_util.modifyNestedColumns_DDL(
tab_owner_v  IN VARCHAR2,
tab_name_v   IN VARCHAR2,
hist         IN VARCHAR2,
added_cols   IN VARCHAR2,
dropped_cols IN VARCHAR2);
TBD
 
NESTEDTABLE_LTSELECT
Undocumented wm_ddl_util.nextedTable_LTSelect(
schema           IN VARCHAR2,
tab_name         IN VARCHAR2,
nt_tab_name      IN VARCHAR2,
hist             IN VARCHAR2,
keycols          IN VARCHAR2,
lt_view_tab_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
REBUILDINDEX
Undocumented wm_ddl_util.rebuildIndex(
table_owner_v     IN VARCHAR2,
table_name_v      IN VARCHAR2,
index_owner_v     IN VARCHAR2,
index_name_v      IN VARCHAR2,
index_options_v   IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
RECREATEORIGINALCONSTRAINTS
Undocumented wm_ddl_util.recreateOroginalConstraints(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist_option IN VARCHAR2,
vt_option   IN NUMBER,
keepwmvalid IN BOOLEAN);
TBD
 
RECREATEORIGINALINDICES
Undocumented wm_ddl_util.recreateOriginalIndices(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
hist_option IN VARCHAR2);
TBD
 
RECREATEPTAFTERTRIGS
Undocumented wm_ddl_util.recreatePTAfterTrigs(
schema     IN VARCHAR2,
table_name IN VARCHAR2,
buffercode IN BOOLEAN);
TBD
 
RENAMECONSTRAINT
Undocumented wm_ddl_util.renameConstraint(
table_owner_v     IN VARCHAR2,
table_name_v      IN VARCHAR2,
cons_name_v       IN VARCHAR2,
new_cons_name_v   IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
RENAMEINDEX
Undocumented wm_ddl_util.renameIndex(
table_owner_v     IN VARCHAR2,
table_name_v      IN VARCHAR2,
index_owner_v     IN VARCHAR2,
index_name_v      IN VARCHAR2,
new_index_name_v  IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
RENAMETABDV
Undocumented wm_ddl_util.renameTabDV(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2);
TBD
 
RENAMETABEV
Undocumented wm_ddl_util.renameTabEV(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2);
TBD
REVOKEWMSYSPRIVS
Undocumented wm_ddl_util.revokeWMSysPrivs(
tab_owner_v  IN VARCHAR2,
tab_name_v   IN VARCHAR2,
ddloperation IN BOOLEAN);
TBD
 
SYNCRONIZEVTVIEWS
Undocumented wm_ddl_util.synchronizeVTViews(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
state             IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WM
LT
LTAQ
LTDTRG
LTI
LTPRIV
WM_ERROR
What's New In 19c
What's New In 20c-21c

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