Oracle | WM_DDL

Oracle WM_DDL_UTIL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Workspace Management Supporting Utilities

AUTHID CURRENT_USER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'WM_DDL_UTIL' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'WM_DDL_UTIL' ORDER BY 1;

Returns 55 objects

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted.

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmdutls.plb
{ORACLE_HOME}/rdbms/admin/owmdutlb.plb

Subprograms

ADDCOLUMNS	CREATETEMPTABLE	GRANTWMSYSPRIVS
ADDUSERCOLUMNS	CREATETEMPTOPVIEW	INDEXCREATEDBYCONSTRAINT
ADDVALIDTIMESUPPORT	CREATETOPVIEW	IS_RIC_CHILD_OF_ENABLED_TABLE
AVTDDL	CREATEUNIONBASEVIEW	IS_RIC_PARENT
BASEVIEW_COMMON	CREATEUSERVIEWS	MODIFYNESTEDCOLUMNSDV
CARRYFORWARDPRIVSQL	CREATEVTTABLE	MODIFYNESTEDCOLUMNSEV
CHECKFORERRORSEV	DELETENONLATESTDATAFROMLIVE	MODIFYNESTEDCOLUMNS_DDL
CHECK_MRIC_CASCADE	DELETENONLIVEDATA	NESTEDTABLE_LTSELECT
CONFVIEW_COMMON	DIFFVIEW_COMMON	REBUILDINDEX
CREATEAUXILIARYTABLE	DROPCONFLICTSRELATED	RECOMPILETABLEOBJECTS
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	GETINDEXSUBCLAUSE

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;

      /

      *

      PLS-00904: insufficient privilege to access object WM_DDL_UTIL

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

RECOMPILETABLEOBJECTS (new 23ai)

Undocumented wm_ddl_util.recompileTableObjects( schema IN VARCHAR2, table_name IN VARCHAR2, vt_option IN NUMBER);

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