Oracle | WM_DDL

Oracle WM_DDL_UTIL 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 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	CREATETEMPTABLE	GETINDEXSUBCLAUSE
ADDUSERCOLUMNS	CREATETEMPTOPVIEW	GRANTWMSYSPRIVS
ADDVALIDTIMESUPPORT	CREATETOPVIEW	INDEXCREATEDBYCONSTRAINT
AVTDDL	CREATEUNIONBASEVIEW	IS_RIC_CHILD_OF_ENABLED_TABLE
BASEVIEW_COMMON	CREATEUSERVIEWS	IS_RIC_PARENT
CARRYFORWARDPRIVSQL	CREATEVTTABLE	MODIFYNESTEDCOLUMNSDV
CHECKFORERRORSEV	DELETENONLATESTDATAFROMLIVE	MODIFYNESTEDCOLUMNSEV
CHECK_MRIC_CASCADE	DELETENONLIVEDATA	MODIFYNESTEDCOLUMNS_DDL
CONFVIEW_COMMON	DIFFVIEW_COMMON	NESTEDTABLE_LTSELECT
CREATEAUXILIARYTABLE	DROPCONFLICTSRELATED	REBUILDINDEX
CREATEBASEVIEW	DROPDIFFRELATED	RECREATEORIGINALCONSTRAINTS
CREATECONFLICTVIEW	DROPWMCOLUMNS	RECREATEORIGINALINDICES
CREATECONSVIEW	FIXCONSTRAINTSEV	RECREATEPTAFTERTRIGS
CREATEDIFFVIEW	FIXINDEXEV	RENAMECONSTRAINT
CREATEHISTORYVIEW	FIXPRIVSEV	RENAMEINDEX
CREATELCKTABLE	GETASSOCIATEDINDEX	RENAMETABDV
CREATELOCKVIEW	GETCOLSTREV	RENAMETABEV
CREATEMWVIEW	GETINDEXCLAUSE	REVOKEWMSYSPRIVS
CREATENESTEDTABLEBASEVIEW	GETINDEXCOLUMNS	SYNCRONIZEVTVIEWS
CREATENESTEDTABLECONSVIEW

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