Oracle LTUTIL
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 Manager Utilities
AUTHID DEFINER
Data Types TYPE CONS_VIOLATION_TAB ....;

TYPE NUMBER_TAB ....;

TYPE NUMBER_TAB_BIN ....;

TYPE ROWID_WCT ....;

TYPE VARCHAR2_TAB_4000_BIN ....;

TYPE WM$FULL_IDENT_TAB ....;

TYPE WM$IDENT_TAB ....;

TYPE WM$IDENT_TAB_BIN ....;
Dependencies
ALL_CONSTRAINTS OWM_DML_PKG WM_PERIOD
ALL_CONS_COLUMNS OWM_DYNSQL_ACCESS WM$NEXTVER_EXP_TAB_TYPE
ALL_IND_COLUMNS OWM_IEXP_PKG WM$NEXTVER_EXP_TYPE
ALL_TABLES OWM_MIG_PKG WM$NEXTVER_TABLE
ALL_TYPE_ATTRS OWM_MP_PKG WM$NEXTVER_TABLE$
ALL_USERS OWM_VSCRIPT_PKG WM$NT_I_TRIG
ALL_VERSION_HVIEW PLITBLM WM$PARVERS_VIEW
ALL_WM_MODIFIED_TABLES UD_TRIGS WM$REMOVED_WORKSPACES_TABLE
ALL_WM_TAB_TRIGGERS USER_WM_MODIFIED_TABLES WM$RESOLVE_WORKSPACES_TABLE$
CCOL$ USER_WM_TAB_TRIGGERS WM$RIC_LOCKING_TABLE
CDEF$ UTL_FILE WM$RIC_TABLE
COL$ VALIDATE_OWM WM$RIC_TABLE$
CON$ WM$BATCH_COMPRESSIBLE_TABLES WM$RIC_TRIGGERS_TABLE
DBA_CONSTRAINTS WM$BATCH_COMPRESSIBLE_TABLES$ WM$RIC_TRIGGERS_TABLE$
DBA_CONS_COLUMNS WM$BCT_I_TRIG WM$RLT_I_TRIG
DBA_DEPENDENCIES WM$CC_I_TRIG WM$RTT_I_TRIG
DBA_EXTENTS WM$COLUMN_PROPS WM$RT_D_TRIG
DBA_HISTOGRAMS WM$CONSTRAINTS_TABLE WM$RT_I_TRIG
DBA_INDEXES WM$CONSTRAINTS_TABLE$ WM$RWT_I_TRIG
DBA_IND_COLUMNS WM$CONS_COLUMNS WM$TABLE_PARVERS_VIEW
DBA_IND_EXPRESSIONS WM$CONS_COLUMNS$ WM$TABLE_WS_PARVERS_VIEW
DBA_IND_PARTITIONS WM$CP_D_TRIG WM$UDP_I_TRIG
DBA_OBJECTS WM$CP_I_TRIG WM$UDTRIG_DISPATCH_PROCS
DBA_OBJECT_TABLES WM$CP_U_TRIG WM$UDTRIG_DISPATCH_PROCS$
DBA_POLICIES WM$CT_I_TRIG WM$UDTRIG_INFO
DBA_SEGMENTS WM$CT_U_TRIG WM$UDTRIG_INFO$
DBA_SEQUENCES WM$CURRENT_CHILD_VERSIONS_VIEW WM$UD_U_TRIG
DBA_SYNONYMS WM$CURRENT_CONS_NEXTVERS_VIEW WM$UI_I_TRIG
DBA_SYS_PRIVS WM$CURRENT_CONS_VERSIONS_VIEW WM$VERSIONED_TABLES
DBA_TABLES WM$CURRENT_NEXTVERS_VIEW WM$VERSIONED_TABLES$
DBA_TABLESPACES WM$CURRENT_PARVERS_VIEW WM$VERSIONED_TABLES$D
DBA_TAB_COLS WM$CURRENT_WORKSPACE_VIEW WM$VERSIONED_TABLES$H
DBA_TAB_COL_STATISTICS WM$DBA_TAB_COLS WM$VERSION_HIERARCHY_TABLE
DBA_TAB_PARTITIONS WM$ED_UNDO_CODE_NODE_TYPE WM$VERSION_HIERARCHY_TABLE$
DBA_TAB_PRIVS WM$EXP_MAP WM$VERSION_SEQUENCE
DBA_TAB_SUBPARTITIONS WM$EXP_MAP_TAB WM$VERSION_TABLE
DBMS_LOB WM$EXP_MAP_TYPE WM$VERSION_TABLE$
DBMS_LOCK WM$HINT_TABLE WM$VET_I_TRIG
DBMS_REGISTRY WM$HINT_TABLE$ WM$VET_U_TRIG
DBMS_RLS WM$HT_I_TRIG WM$VHT_I_TRIG
DBMS_ROWID WM$IDENT_TAB_TYPE WM$VT_ERRORS_TABLE
DBMS_SESSION WM$INTERNAL_OBJECTS WM$VT_ERRORS_TABLE$
DBMS_STANDARD WM$LI_I_TRIG WM$VT_I_TRIG
DBMS_UTILITY WM$LOCKROWS_INFO WM$WORKSPACES_TABLE
DUAL WM$LOCKROWS_INFO$ WM$WORKSPACES_TABLE$
LT WM$MGWT_I_TRIG WM$WORKSPACES_TABLE$D
LTADM WM$MIGRATION_ERROR_VIEW WM$WORKSPACE_PRIV_TABLE
LTAQ WM$MODIFIED_TABLES WM$WORKSPACE_PRIV_TABLE$
LTDDL WM$MODIFIED_TABLES$ WM$WORKSPACE_SAVEPOINTS_TABLE
LTDTRG WM$MPWT_I_TRIG WM$WORKSPACE_SAVEPOINTS_TABLE$
LTPRIV WM$MP_GRAPH_WORKSPACES_TABLE WM$WPT_D_TRIG
LTRIC WM$MP_GRAPH_WORKSPACES_TABLE$ WM$WPT_I_TRIG
LT_CTX_PKG WM$MP_PARENT_WORKSPACES_TABLE$ WM$WPT_U_TRIG
LT_EXPORT_PKG WM$MT_I_TRIG WM$WST_I_TRIG
NOEXP$ WM$MW_I_TRIG WM$WT_I_TRIG
OBJ$ WM$MW_TABLE$ WM_COMPRESSIBLE_TABLES
OWM_ASSERT_PKG WM$MW_VERSIONS_VIEW_9I WM_DDL_UTIL
OWM_BULK_LOAD_PKG WM$NCT_I_TRIG WM_ERROR
OWM_CPKG_PKG WM$NESTED_COLUMNS_TABLE WM_INSTALLATION
OWM_DDL_PKG WM$NESTED_COLUMNS_TABLE$  
Documented No
Exceptions
Error Code Reason
ORA-00904 "LTUTIL"."GETWORKSPACELOCKMODE": invalid identifier
   
   
First Available Not known
Security Model Owned by WMSYS with no privileges granted
Some subprograms are protected by an ACCESSIBLE BY clause
Source {ORACLE_HOME}/rdbms/admin/owmutls.plb
{ORACLE_HOME}/rdbms/admin/owmutlb.plb
Subprograms
ADDUSERDEFINEDHINT GETDEFAULTWORKSPACEID INSERTFULLROLLBACKMARKER
ADDWCP GETDEFAULTWORKSPACENAME INSERTNEXTVERS
ALLOCATE_UNIQUE GETDESCVERSIONS INSERTVERSION
ALLOWROWLEVELLOCKING GETDISTINCTOBJECT INVERSIONEDSTATE
BITCLEAR GETDISVER ISIMPLICITSP
BITOR GETHISTOPTION ISLEAFSTATE
CHECKADDTOPOGEOLAYERERRORS GETINDEXTABLE ISMODIFIED
CHECKDELTOPOGEOLAYERERRORS GETINDEXTABLESPACE ISMODIFIEDINSUBTREE
CHECKDOMAININDEXPRIVS GETMINWORKSPACEVERSION ISOBJECTTABLE
CHOOSE GETNESTEDCOLUMNVIEW ISSPATIALINSTALLED
CLEANUPBDDL GETNESTEDTABLECOLSTR ISSPLITINSUBTREE
CLEANUPCDDL GETNESTEDTABLEMETADATACOLUMNS ISTOPOFEATURETABLE
CLEANUPDV GETNESTEDTABLETYPE ISTOPOLOGYINDEXTABLE
CLEANUPEV GETNEXTVERSION ISTOPOLOGYRELATIONTABLE
CLEANUPMETADATA GETNOTNULLCONSTRAINT ISVERSIONEDTABLE
CLEANUPMETADATABYUSER GETNTPKEYCOLS ISVERSIONENABLEDTOPOLOGY
CLEANUPSTALEMETADATA GETPIPELINEDTABLE ISWORKSPACEOWNER
CONTRACTWHITESPACE GETPKEYCOLS MOVEWMMETADATA
CONTRACTWHITESPACECLOB GETPKEYINFO NEEDTOEXECUTETRIGGERS
COPYRLSPOLICIES GETPKEYINFO_VT NUMTRIGGERSTOEXECUTE
CREATEINLISTFROMQUERY GETPKINDEXINFO PARSESTRINGLIST
CREATEPKWHERECLAUSE GETRICSTATUS PIPED_ROWID_FUNC
DELETEFULLROLLBACKMARKER GETRLSWHERECLAUSE POPULATEROWIDRANGES
DELETEUNDOCODE GETSEQUENCEOPTIONS PREFIXSTR
DELETEUNDOCODERANGE GETSID QB_BLOCK_REPLACE
DELETE_ALL_SDO_GEOM_METADATA GETSNO REMOVEUSERDEFINEDHINT
DISALLOWIFWITHVT GETSPACEUSAGE RENAMESAVEPOINT
DROPRLSPOLICIES GETSTATEFROMVER RENAMEWORKSPACE
DROPUNUSEDCOLUMNS GETTABLETABLESPACE REQUIRESTRIGGERSONTOPVIEW
EXECEVUNDO GETTOPOFEATURETABINFO RESETALLSEQUENCES
EXECLOG GETTOPOINFO RESOLVESYNONYM
EXECUTESQLLOG GETTRIGFLAG RESTARTSEQUENCE
EXISTSBIR GETTRIGGERS ROLLBACKTOTXNSAVEPOINT
EXISTSBUR GETTRIGTYPES ROWSINVERSFROMHISTOGRAM
EXISTSCONSTRAINT GETUDHINT SEPARATECLOBINTO2PARTS
EXISTSFULLROLLBACKMARKER GETUNDOCODECLOB SETDEBUGOPTIONS
EXISTSTOPOLOGY GETVALIDTIMEOPTION SETDISVER
FIXTOPOLOGYIMPORT GETVARIABLE_R SETTXNSAVEPOINT
FIXVTAB_COMPRESS GETVERINDEXNAME SETVARIABLE
FIXVTAB_REFRESH GETVN SKIPOBJECTSDURINGEXPORT
FIXVTAB_ROLLBACK GETVTID STRIPVERSION
GENFIXCRNONSEQNFRESHINS GETWHERECLAUSESTR STRIPVERSIONRANGE
GENWMCOLSUPDATESTMNT GETWORKSPACELOCKID STUFFVERSION
GETBASETABLENAME GETWORKSPACELOCKMODE STUFFVERSIONRANGE
GETBATCHWHERECLAUSES GET_EXPANDED_NEXTVERS SUBSVERSION
GETCOLINFO GET_EXPANDED_NEXTVERS_NP TOPOTABLECHECK
GETCOLLIST GRANTOLSPRIVS TO_CLOB_
GETCOLSTR HASCRCHILD UPDATESDOTOPOMETADATADV
GETCOLUMNDECLARATION HASDEFERREDCHILD UPDATESDOTOPOMETADATAEV
GETCOLUMNPLUSEXPRESSION HASFEATURETABLE VT_FIXNVTAB
GETCONTAINEDVER HASNESTEDTABLECOLUMN WM$CONCAT
GETCONTAINEDVERINRANGE HASOLSPOLICY WM$CONVERTVERSIONSTR
GETCONTAINEDVERSINWORKSPACE HASRICCASCADINGCONSTRAINT WM$GETDBCOMPATIBLESTR
GETCONTAINEDVERSIONRANGE HASRICSETNULLCONSTRAINT WM$GETDBVERSIONSTR
GETCRNEXTVERS HASVIRTUALCOLUMN WM$GETERRORS
GETCRSTATUS HASWOOVERWRITEOPTION WM$SORTSTRING
GETCURRENTLOCKINGMODE HISTWITHDATETYPE WRITETOLOG
GETCURVER HISTWITHDATETYPEEV WRITEUNDOCODE
 
ADDUSERDEFINEDHINT
Undocumented ltutil.adduserdefinedhint(
hint_id_var IN NUMBER,
hint        IN VARCHAR2,
schema      IN VARCHAR2,
tab_name    IN VARCHAR2);
TBD
 
ADDWCP
Undocumented ltutil.addwcp(
wc           IN VARCHAR2,
before_after IN VARCHAR2,
conjunction  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
ALLOCATE_UNIQUE
Undocumented ltutil.allocate_unique(
lockname   IN  VARCHAR2,
lockhandle OUT VARCHAR2);
TBD
 
ALLOWROWLEVELLOCKING
Undocumented ltutil.allowrowlevellocking(
state  IN VARCHAR2,
opcode IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
BITCLEAR
Undocumented ltutil.bitclear(
val1 IN NUMBER,
val2 IN NUMBER)
RETURN NUMBER;
SELECT wmsys.ltutil.bitclear(6,2)
FROM dual;

WMSYS.LTUTIL.BITCLEAR(6,2)
--------------------------
                         4
 
BITOR
Undocumented ltutil.bitor(
val1 IN NUMBER,
val2 IN NUMBER)
RETURN NUMBER;
SELECT wmsys.ltutil.bitor(7,8)
FROM dual;

WMSYS.LTUTIL.BITCLEAR(7,8)
--------------------------
                        15
 
CHECKADDTOPOGEOLAYERERRORS
Undocumented ltutil.checkaddtopogeolayererrors(
topology_owner           IN VARCHAR2,
topology                 IN VARCHAR2,
table_owner_var          IN VARCHAR2,
table_name_var           IN VARCHAR2,
column_name              IN VARCHAR2,
topo_geometry_layer_type IN VARCHAR2);
TBD
 
CHECKDELTOPOGEOLAYERERRORS
Undocumented ltutil.checkdeltopogeolayererrors(
topology_owner  IN VARCHAR2,
topology        IN VARCHAR2,
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
column_name     IN VARCHAR2);
TBD
 
CHECKDOMAININDEXPRIVS
Undocumented ltutil.checkdomainindexprivs(
table_owner IN VARCHAR2,
table_name  IN VARCHAR2);
TBD
 
CHOOSE
Testing indicates that FALSE selects the first string, TRUE the second. ltutil.choose(
str1 IN VARCHAR2,
str2 IN VARCHAR2,
flag IN BOOLEAN)
RETURN VARCHAR2;
DECLARE
 retVal dbms_id;
BEGIN
  retVal := wmsys.ltutil.choose('Daniel', 'Morgan', FALSE);
  dbms_output.put_line(retVal);
  retVal := wmsys.ltutil.choose('Daniel', 'Morgan', TRUE);
  dbms_output.put_line(retVal);
END;
/
Daniel
Morgan

PL/SQL procedure successfully completed.
 
CLEANUPBDDL
Undocumented ltutil.cleanupbddl(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
CLEANUPCDDL
Undocumented ltutil.cleanupcddl(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN,
resetdisver       IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
CLEANUPDV
Undocumented ltutil.cleanupdv(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
CLEANUPEV
Undocumented ltutil.cleanupev(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
CLEANUPMETADATA
Undocumented ltutil.cleanupmetadata(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2);
TBD
 
CLEANUPMETADATABYUSER
Protected by an ACCESSIBLE BY clause ltutil.cleanupmetadatabyuser(schema IN VARCHAR2);
exec wmsys.ltutil.cleanupmetadatabyuser('C##TESTUSER');
BEGIN wmsys.ltutil.cleanupmetadatabyuser('C##TESTUSER'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object CLEANUPMETADATABYUSER
 
CLEANUPSTALEMETADATA
Protected by an ACCESSIBLE BY clause ltutil.cleanupstalemetadata;
exec wmsys.ltutil.cleanupstalemetadata;
BEGIN wmsys.ltutil.cleanupstalemetadata; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object CLEANUPSTALEMETADATA
 
CONTRACTWHITESPACE
All 4 examples, at right contain a total of 5 spaces (CHR 32). In the second demo the leading spaces are reduced from 4 to 1 ltutil.contractwhitespace(str IN VARCHAR2) RETURN VARCHAR2;
SELECT LENGTH(wmsys.ltutil.contractwhitespace('Morgan''s     Library'))
FROM dual;

LENGTH(WMSYS.LTUTIL.CONTRACTWHITESPACE('MORGAN''SLIBRARY'))
-----------------------------------------------------------
                                                         20

SELECT LENGTH(wmsys.ltutil.contractwhitespace('    Morgan''s Library'))
FROM dual;

LENGTH(WMSYS.LTUTIL.CONTRACTWHITESPACE('MORGAN''SLIBRARY'))
-----------------------------------------------------------
                                                         17

SELECT LENGTH(wmsys.ltutil.contractwhitespace('Morgan''s Library    '))
FROM dual;

LENGTH(WMSYS.LTUTIL.CONTRACTWHITESPACE('MORGAN''SLIBRARY'))
-----------------------------------------------------------
                                                         20
 
CONTRACTWHITESPACECLOB
Undocumented ltutil.contractwhitespaceclob(c IN CLOB) RETURN CLOB;
DECLARE
 InVal  CLOB := 'x                    x                    x';
 retVal CLOB;
BEGIN
  retVal := wmsys.ltutil.contractwhitespaceclob(inVal);
  dbms_output.put_line(LENGTH(retVal));
END;
/
5

PL/SQL procedure successfully completed.
 
COPYRLSPOLICIES
Undocumented ltutil.copyrlspolicies(
source_owner IN VARCHAR2,
source_name  IN VARCHAR2,
target_owner IN VARCHAR2,
target_name  IN VARCHAR2,
log_undo     IN BOOLEAN);
TBD
 
CREATEINLISTFROMQUERY
Undocumented ltutil.createinlistfromquery(
sqlstr  IN VARCHAR2,
using_t IN wmsys.ltutil.wm$full_ident_tab,
maxs    IN NUMBER)
RETURN VARCHAR2;
TBD
 
CREATEPKWHERECLAUSE
Undocumented ltutil.createpkwhereclause(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
DELETEFULLROLLBACKMARKER
Undocumented ltutil.deletefullrollbackmarker(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
DELETEUNDOCODE
Undocumented ltutil.deleteundocode(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
index_type_var  IN NUMBER,
index_var       IN NUMBER);
TBD
 
DELETEUNDOCODERANGE
Undocumented ltutil.deleteundocoderange(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
minvalue        IN NUMBER,
maxvalue        IN NUMBER);
TBD
 
DELETE_ALL_SDO_GEOM_METADATA
Undocumented ltutil.delete_all_sdo_geom_metadata(
owner           IN VARCHAR2,
old_table_name  IN VARCHAR2,
old_column_name IN VARCHAR2);
TBD
 
DISALLOWIFWITHVT
Undocumented ltutil.disallowifwithvt(
owner_name_var IN VARCHAR2,
table_name_var IN VARCHAR2,
operation_name IN VARCHAR2);
TBD
 
DROPRLSPOLICIES
Undocumented ltutil.droprlspolicies(
source_owner IN VARCHAR2,
source_name  IN VARCHAR2);
TBD
 
DROPUNUSEDCOLUMNS
Undocumented ltutil.dropunusedcolumns(
table_owner IN VARCHAR2,
table_name  IN VARCHAR2);
TBD
 
EXECEVUNDO
Undocumented ltutil.execevundo(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN,
opcode            IN VARCHAR2);
TBD
 
EXECLOG
Undocumented ltutil.execlog(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN,
state_var         IN VARCHAR2,
operationvar      IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
EXECUTESQLLOG
Undocumented ltutil.executesqllog(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
EXISTSBIR
Undocumented ltutil.existsbir(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSBUR
Undocumented ltutil.existsbur(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSCONSTRAINT
Undocumented ltutil.existsconstraint(
table_owner_var     IN VARCHAR2,
table_name_var      IN VARCHAR2,
constraint_name_var IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSFULLROLLBACKMARKER
Undocumented ltutil.existsfullrollbackmarker(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSTOPOLOGY
Undocumented ltutil.existstopology(
topo_owner_var IN VARCHAR2,
topo_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
FIXTOPOLOGYIMPORT
Undocumented ltutil.fixtopologyimport(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2);
TBD
 
FIXVTAB_COMPRESS
Undocumented ltutil.fixvtab_compress(
instate  IN VARCHAR2,
startver IN NUMBER,
endver   IN NUMBER);
TBD
 
FIXVTAB_REFRESH
Undocumented ltutil.fixvtab_refresh(
rfh_state IN VARCHAR2,
parstate  IN VARCHAR2,
parver    IN NUMBER);
TBD
 
FIXVTAB_ROLLBACK
Undocumented ltutil.fixvtab_rollback(
instate IN VARCHAR2,
cpver   IN NUMBER);
TBD
 
GENFIXCRNONSEQNFRESHINS
Undocumented ltutil.genFixCrnonSeqnFreshins(
schemaname        IN VARCHAR2,
tab_name          IN VARCHAR2,
targetcurver      IN NUMBER,
pkey_cols         IN VARCHAR2,
pkey_where_clause IN VARCHAR2,
pkey_params       IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GENWMCOLSUPDATESTMNT
Undocumented ltutil.genWMColsUpdateStmnt(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
histoption    IN VARCHAR2,
vt_option     IN NUMBER,
vtrange       IN wmsys.wm_period,
undospace     IN VARCHAR2);
TBD
 
GETBASETABLENAME
Undocumented ltutil.getbasetablename(
tab_owner IN     VARCHAR2,
tab_name  IN OUT VARCHAR2,
bv           OUT BOOLEAN);
TBD
 
GETBATCHWHERECLAUSES
Undocumented ltutil.getbatchwhereclauses(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN wmsys.ltutil.varchar2_tab_4000_bin;
TBD
 
GETCOLINFO
Undocumented ltutil.getcolinfo(
owner_name          IN  VARCHAR2,
tab_name            IN  VARCHAR2,
col_names           OUT VARCHAR2,
pkey_col_type_decls OUT VARCHAR2,
pkey_col_names      OUT VARCHAR2);
TBD
 
GETCOLLIST
Undocumented ltutil.getcollist(
owner_name       IN  VARCHAR2,
tab_name         IN  VARCHAR2,
col_names        OUT VARCHAR2,
col_names_no_pfx OUT VARCHAR2);
TBD
 
GETCOLSTR
Undocumented ltutil.getcolstr(
schema          IN VARCHAR2,
tab_name        IN VARCHAR2,
prefix_str      IN VARCHAR2,
include_virtual IN NUMBER,
exclude_all_wm  IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETCOLUMNDECLARATION
Undocumented ltutil.getcolumndeclaration(
datatype_owner IN VARCHAR2,
datatype       IN VARCHAR2,
datatype_mod   IN VARCHAR2,
l_length       IN NUMBER,
l_char_length  IN NUMBER,
l_char_used    IN VARCHAR2,
l_precision    IN NUMBER,
l_scale        IN NUMBER,
l_data_default  IN LONG,
resolve_synonym IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GETCOLUMNPLUSEXPRESSION
Undocumented ltutil.getcolumnplusexpression(
indowner IN VARCHAR2,
indname  IN VARCHAR2,
indtype  IN VARCHAR2,
colname  IN VARCHAR2,
colpos   IN NUMBER,
descend  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETCONTAINEDVER
Undocumented ltutil.getContainedver(
in_nextver        IN VARCHAR2,
instate           IN VARCHAR2,
mp_root_workspace IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETCONTAINEDVERINRANGE
Undocumented ltutil.getContainedverinRange(
in_nextver IN VARCHAR2,
tab_name   IN VARCHAR2,
instate    IN VARCHAR2,
beginver   IN NUMBER,
endver     IN NUMBER)
RETURN NUMBER;
TBD
 
GETCONTAINEDVERSINWORKSPACE
Undocumented ltutil.getContainedversinWorkspace(
in_nextver        IN VARCHAR2,
instate           IN ARCHAR2,
mp_root_workspace IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETCONTAINEDVERSIONRANGE
Undocumented ltutil.getContainedVersionRange(
wm_nextver    IN VARCHAR2,
version_range IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETCRNEXTVERS
Undocumented ltutil.getcrNextVers(
curver     IN     NUMBER,
oldnextver IN OUT VARCHAR2,
newnextver IN OUT VARCHAR2);
TBD
 
GETCRSTATUS
Undocumented ltutil.getcrStatus(workspace_var IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GETCURRENTLOCKINGMODE
Undocumented ltutil.getCurrentLockingMode RETURN VARCHAR2;
SELECT wmsys.ltutil.getCurrentLockingMode
FROM dual;
SELECT wmsys.ltutil.getCurrentLockingMode
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object GETCURRENTLOCKINGMODE
 
GETCURVER
Undocumented ltutil.getCurVer RETURN NUMBER;
SELECT wmsys.ltutil.getCurVer
FROM dual;
SELECT wmsys.ltutil.getCurVer
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object GETCURVER
 
GETDEFAULTWORKSPACEID
Undocumented ltutil.getDefaultWorkspaceid RETURN NUMBER;
SELECT wmsys.ltutil.getDefaultWorkspaceid
FROM dual;

GETDEFAULTWORKSPACEID
---------------------
                    0
 
GETDEFAULTWORKSPACENAME
Undocumented ltutil.getDefaultWorkspaceName RETURN VARCHAR2;
SELECT wmsys.ltutil.getDefaultWorkspaceName
FROM dual;

GETDEFAULTWORKSPACENAME
------------------------
LIVE
 
GETDESCVERSIONS
Undocumented ltutil.getdescversions(
curver           IN  NUMBER,
wm$dvtabversions OUT wmsys.ltutil.number_tab,
wm$dvtabdescvers OUT wmsys.ltutil.number_tab,
fromcurwspc      IN BOOLEAN);
TBD
 
GETDISTINCTOBJECT
Undocumented ltutil.getdistinctobject(schema IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GETDISVER
Undocumented ltutil.getdisver(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETHISTOPTION
Undocumented ltutil.gethistoption(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETINDEXTABLE
Undocumented ltutil.getindextable(
feature_owner IN  VARCHAR2,
feature_name  IN  VARCHAR2,
column_name   IN  VARCHAR2,
index_owner   OUT VARCHAR2,
index_table   OUT VARCHAR2);
TBD
 
GETINDEXTABLESPACE
Undocumented ltutil.getindextablespace(
index_owner_var IN VARCHAR2,
index_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETMINWORKSPACEVERSION
Undocumented ltutil.getminworkspaceversion(workspace_var IN VARCHAR2) RETURN NUMBER;
TBD
 
GETNESTEDCOLUMNVIEW
Undocumented ltutil.getnestedcolumnview(
tab_owner        IN VARCHAR2,
tab_name         IN VARCHAR2,
colstr           IN VARCHAR2,
view_name        IN VARCHAR2,
where_clause     IN VARCHAR2,
lt_view_tab_name IN VARCHAR2,
prefixed_colstr  IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GETNESTEDTABLECOLSTR
Undocumented ltutil.getnestedtablecolstr(
l_type_owner IN VARCHAR2,
l_type_name  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETNESTEDTABLEMETADATACOLUMNS
Undocumented ltutil.getnestedtablemetadatacolumns(
tab_owner IN VARCHAR2,
tab_name  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETNESTEDTABLETYPE
Undocumented ltutil.getnestedtabletype(
owner_name IN VARCHAR2,
tab_name   IN VARCHAR2)
RETURN VARcHAR2;
TBD
 
GETNEXTVERSION
Undocumented ltutil.getnextversion RETURN NUMBER;
SELECT wmsys.ltutil.getnextversion
FROM dual;
SELECT wmsys.ltutil.getnextversion FROM dual
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object GETNEXTVERSION
 
GETNOTNULLCONSTRAINT
Undocumented ltutil.getnotnullconstraint(
tab_owner IN VARCHAR2,
tab_name  IN VARCHAR2,
colname   IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETNTPKEYCOLS
Undocumented ltutil.getntpkeycols(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETPIPELINEDTABLE
Undocumented ltutil.getpipelinedtable(
fmode IN NUMBER,
nval1 IN NUMBER,
nval2 IN NUMBER,
vval1 IN VARCHAR2,
vval2 IN VARCHAR2)
RETURN wmsys.wm$exp_map_tab;
TBD
 
GETPKEYCOLS
Undocumented ltutil.getpkeycols(
schema          IN VARCHAR2,
tab_name        IN VARCHAR2,
include_virtual IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETPKEYINFO
Undocumented ltutil.getpkeyinfo(
schema      IN  VARCHAR2,
tab_name    IN  VARCHAR2,
pkindexname OUT VARCHAR2,
pkcols      OUT VARCHAR2);
TBD
 
GETPKEYINFO_VT
Undocumented ltutil.getpkeyinfo_vt(
schema                 IN  VARCHAR2,
tab_name               IN  VARCHAR2,
pkey_cols              OUT VARCHAR2,
pkey_cols_nv           OUT VARCHAR2,
pkey_cols_noprefix     OUT VARCHAR2,
pkey_cols_nv_noprefix  OUT VARCHAR2,
pkey_col_decls         OUT VARCHAR2,
pkey_col_vals          OUT VARCHAR2,
pkey_col_vals_idx      OUT VARCHAR2,
pkey_where_clause_fins OUT VARCHAR2,
pkey_params_fins       OUT VARCHAR2,
join_clause1           OUT VARCHAR2,
join_clause2           OUT VARCHAR2,
oj_join_clause         OUT VARCHAR2,
join_clause_fins       OUT VARCHAR2,
pkey_col_decls_fins    OUT VARCHAR2,
pkey_col_vals_fins     OUT VARCHAR2,
pkey_col_vals_idx_fins OUT VARCHAR2);
TBD
 
GETPKINDEXINFO
Undocumented ltutil.getpkindexinfo(
table_owner_var IN  VARCHAR2,
table_name_var  IN  VARCHAR2,
pkidxowner      OUT VARCHAR2,
pkidxname       OUT VARCHAR2);
TBD
 
GETRICSTATUS
Undocumented ltutil.getricstatus(
owner_name IN VARCHAR2,
tab_name   IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETRLSWHERECLAUSE
Undocumented ltutil.getrlswhereclause(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETSEQUENCEOPTIONS
Undocumented ltutil.getsequenceoptions(
seqowner IN VARCHAR2,
seqname  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETSID
Undocumented ltutil.getsid(curusid IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSNO
Undocumented ltutil.getsno(curusid IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSPACEUSAGE
Undocumented ltutil.getspaceusage(schema_name IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSTATEFROMVER
Undocumented ltutil.getstatefromver(in_ver IN NUMBER) RETURN VARCHAR2;
TBD
 
GETTABLETABLESPACE
Undocumented ltutil.gettabletablespace(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETTOPOFEATURETABINFO
Undocumented ltutil.gettopofeaturetabinfo(
table_owner_var      IN  VARCHAR2,
table_name_var       IN  VARCHAR2,
topology_owner_var   OUT VARCHAR2,
topology_name_var    OUT VARCHAR2,
topoindextableowners OUT wmsys.ltutil.wm$ident_tab,
topoindextablenames  OUT wmsys.ltutil.wm$ident_tab,
topogeocolnames      OUT wmsys.ltutil.wm$ident_tab);
TBD
 
GETTOPOINFO
Undocumented ltutil.gettopoinfo(
topo_owner_var IN  VARCHAR2,
topo_name_var  IN  VARCHAR2,
tol_var        OUT NUMBER,
srid_var       OUT NUMBER,
ub_var         OUT NUMBER,
lb_var         OUT NUMBER);
TBD
 
GETTRIGFLAG
Undocumented ltutil.gettrigflag(v IN VARCHAR2) RETURN NUMBER;
TBD
 
GETTRIGGERS
Undocumented ltutil.gettriggers(
table_owner  IN VARCHAR2,
table_name   IN VARCHAR2,
triggerevent IN NUMBER,
trig_type    IN VARCHAR2)
RETURN REF_CURSOR;
TBD
 
GETTRIGTYPES
Undocumented ltutil.gettrigtypes(val IN NUMBER) RETURN VARCHAR2;
TBD
 
GETUDHINT
Undocumented ltutil.getudhint(
hint_id_var     IN NUMBER,
tab_owner_v     IN VARCHAR2,
tab_name_v      IN VARCHAR2,
table_list      IN VARCHAR2,
additional_hint IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETUNDOCODECLOB
Undocumented ltutil.getundocodeclob(
table_owner      IN VARCHAR2,
table_name       IN VARCHAR2,
descending_order IN BOOLEAN)
RETURN REF CURSOR;
TBD
 
GETVALIDTIMEOPTION
Undocumented ltutil.getvalidtimeoption(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETVARIABLE_R
Undocumented ltutil.getVariable_r(varname IN VARCHAR2) RETURN wmsys.ltutil.rowid_wct;
TBD
 
GETVERINDEXNAME
Undocumented ltutil.getVerIndexName(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETVN
Undocumented ltutil.getvn(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
ext             IN VARCHAR2,
vtid            IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETVTID
Undocumented ltutil.getvtid(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETWHERECLAUSESTR
Undocumented ltutil.getWhereClauseStr(
str        IN VARCHAR2,
prfx1      IN VARCHAR2,
prfx2      IN VARCHAR2,
outer_join IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GETWORKSPACELOCKID
Undocumented ltutil.getWorkspaceLockid(workspace_var IN VARCHAR2) RETURN NUMBER;
TBD
 
GETWORKSPACELOCKMODE
Undocumented ltutil.getWorkspaceLockMode(workspace_var IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GET_EXPANDED_NEXTVERS
Undocumented ltutil.get_expanded_nextvers(curr_nv IN VARCHAR2) RETURN wmsys.wm$nextver_exp_tab_type;
TBD
 
GET_EXPANDED_NEXTVERS_NP
Undocumented ltutil.get_expanded_nextvers_np(curr_nv IN VARCHAR2) RETURN wmsys.wm$nextver_exp_tab_type;
TBD
 
GRANTOLSPRIVS
Protected by an ACCESSIBLE BY clause ltutil.grantOLSprivs(policy_name IN VARCHAR2);
TBD
 
HASCRCHILD
Undocumented ltutil.hasCRChild(parent_workspace_var IN VARCHAR2) RETURN BOOLEAN;
TBD
 
HASDEFERREDCHILD
Undocumented ltutil.hasDeferredChild(state IN VARCHAR2) RETURN BOOLEAN;
TBD
 
HASFEATURETABLE
Undocumented ltutil.hasFeatureTable(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASNESTEDTABLECOLUMN
Undocumented ltutil.hasNestedTableColumn(
owner_name IN VARCHAR2,
tab_name   IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASOLSPOLICY
Protected by an ACCESSIBLE BY clause ltutil.hasOLSpolicy(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASRICCASCADINGCONSTRAINT
Undocumented ltutil.hasricCascadingConstraint(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASRICSETNULLCONSTRAINT
Undocumented ltutil.hasricSetNullConstraint(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASVIRTUALCOLUMN
Undocumented ltutil.hasVirtualColumn(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASWOOVERWRITEOPTION
Undocumented ltutil.haswooverWriteOption(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HISTWITHDATETYPE
Undocumented ltutil.histWithDateType(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HISTWITHDATETYPEEV
Undocumented ltutil.histWithDateYypeev(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
INSERTFULLROLLBACKMARKER
Undocumented ltutil.insertFullRollbackMarker(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
INSERTNEXTVERS
Undocumented ltutil.insertNextVers(
newnextver IN VARCHAR2,
split      IN NUMBER);
TBD
 
INSERTVERSION
Undocumented

Overload 1		 ltutil.insertVersion(wm_nextver IN VARCHAR2) RETURN VARCHAR2;
TBD
Undocumented

Overload 2		 ltutil.insertVersion(
wm_nextver IN  VARCHAR2,
curver     IN  NUMBER,
parver     IN  NUMBER,
curstate   IN  VARCHAR2,
crstatus   IN  VARCHAR2,
in_vtid    IN  NUMBER,
parnextver OUT VARCHAR2,
curnextver OUT VARCHAR2);
TBD
 
INVERSIONEDSTATE
Undocumented ltutil.inVersionedState(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISIMPLICITSP
Undocumented ltutil.isImplicitsp(
workspace_name IN VARCHAR2,
savepoint_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISLEAFSTATE
Undocumented ltutil.isLeafState(
state_id       IN NUMBER,
cpver          IN NUMBER,
mp_check       IN BOOLEAN,
deferred_check IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
ISMODIFIED
Undocumented ltutil.isModified(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
state_name        IN VARCHAR2,
version_num       IN NUMBER,
checkwithequality IN BOOLEAN,
mp_root_workspace IN VARCHAR2,
oper_type         IN NUMBER,
leaf_workspace    IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISMODIFIEDINSUBTREE
Undocumented ltutil.isModifiedInsubtree(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
state_name      IN VARCHAR2,
checksubtree    IN BOOLEAN,
querytable      IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
ISOBJECTTABLE
Returns TRUE if the table is an object table, else FALSE ltutil.isObjectTable(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISSPATIALINSTALLED
Undocumented ltutil.isSpatialInstalled(topo IN BOOLEAN) RETURN BOOLEAN;
TBD
 
ISSPLITINSUBTREE
Undocumented ltutil.isSplitInsubtree(state_name IN VARCHAR2) RETURN BOOLEAN;
TBD
 
ISTOPOFEATURETABLE
Undocumented ltutil.isTopoFeatureTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISTOPOLOGYINDEXTABLE
Undocumented ltutil.isTopologyIndexTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISTOPOLOGYRELATIONTABLE
Undocumented ltutil.isTopologyRelationTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISVERSIONEDTABLE
Undocumented ltutil.isVersionedTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISVERSIONENABLEDTOPOLOGY
Undocumented ltutil.isVersionEnabledTopology(
topo_owner IN VARCHAR2,
topology   IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISWORKSPACEOWNER
Undocumented ltutil.isWorkspaceOwner(
user_name     IN VARCHAR2,
workspace_var IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
MOVEWMMETADATA
Undocumented ltutil.moveWMmetadata(new_tablespace IN VARCHAR2);
TBD
 
NEEDTOEXECUTETRIGGERS
Undocumented ltutil.needToExecuteTriggers(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
triggerevent    IN NUMBER,
trig_type       IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
NUMTRIGGERSTOEXECUTE
Undocumented ltutil.numTriggersToExecute(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
triggerevent    IN NUMBER,
trig_type       IN VARCHAR2)
RETURN NUMBER;
TBD
 
PARSESTRINGLIST
Undocumented ltutil.parseStringList(
str     IN  VARCHAR2,
tab1    OUT wmsys.ltutil.wm$ident_tab,
tab2    OUT wmsys.ltutil.wm$ident_tab,
delim1  IN  VARCHAR2,
delim2  IN  VARCHAR2,
defval2 IN  VARCHAR2);
TBD
 
PIPED_ROWID_FUNC
Undocumented ltutil.piped_rowid_func(rowidtab IN wmsys.wm$ident_tab_type)
RETURN wmsys.wm$ident_tab_type;
TBD
 
POPULATEROWIDRANGES
Undocumented ltutil.populateRowidRanges(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
undospace     IN VARCHAR2);
TBD
 
PREFIXSTR
Protected by an ACCESSIBLE BY clause ltutil.prefixStr(
prfx IN VARCHAR2,
str  IN VARCHAR2)
RETURN VARCHAR2;
SELECT wmsys.ltutil.prefixStr('Professor ', 'Morgan')
FROM dual;
SELECT wmsys.ltutil.prefixStr('Professor ', 'Morgan')
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object PREFIXSTR
 
QB_BLOCK_REPLACE
Undocumented ltutil.qb_block_replace(str IN VARCHAR2) RETURN VARCHAR2;
TBD
 
REMOVEUSERDEFINEDHINT
Undocumented ltutil.removeUserDefinedHint(
hint_id_var IN NUMBER,
schema      IN VARCHAR2,
tab_name    IN VARCHAR2);
TBD
 
RENAMESAVEPOINT
Note that the parameters and usage are exactly the same as the DBMS_WM procedure of the same name ltutil.renameSavepoint(
workspace_name     IN VARCHAR2,
old_savepoint_name IN VARCHAR2,
new_savepoint_name IN VARCHAR2);
exec dbms_wm.renamesavepoint('WS1', 'SP1', 'SP_FIRST');
 
RENAMEWORKSPACE
Note that the parameters and usage are exactly the same as the DBMS_WM procedure of the same name ltutil.renameWorkspace(
old_workspace_name IN VARCHAR2,
new_workspace_name IN VARCHAR2);
exec dbms_wm.renameWorkspace('ws1', 'wsFirst');
 
REQUIRESTRIGGERSONTOPVIEW
Undocumented ltutil.requiresTriggersonTopView(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
RESETALLSEQUENCES
Protected by an ACCESSIBLE BY clause ltutil.resetAllSequences(importoperation IN BOOLEAN);
exec wmsys.ltutil.resetAllSequences(TRUE);
BEGIN wmsys.ltutil.resetAllSequences(TRUE); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object RESETALLSEQUENCES
 
RESOLVESYNONYM
Undocumented ltutil.resolveSynonym(
owner_var IN OUT VARCHAR2,
name_var  IN OUT VARCHAR2);
TBD
 
RESTARTSEQUENCE
Protected by an ACCESSIBLE BY clause ltutil.restartSequence(
seq_owner IN VARCHAR2,
seq_name  IN VARCHAR2,
value_v   IN NUMBER);
CREATE SEQUENCE testseq;

SELECT testseq.NEXTVAL FROM dual;

/

/

/

/

exec wmsys.ltutil.restartSequence(USER, 'TESTSEQ', 1);
BEGIN wmsys.ltutil.restartSequence(USER, 'TESTSEQ', 1); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object RESTARTSEQUENCE
 
ROLLBACKTOTXNSAVEPOINT
Undocumented ltutil.rollbackToTxnSavepoint;
exec wmsys.ltutil.rollbacktotxnsavepoint;

PL/SQL procedure successfully completed.
 
ROWSINVERSFROMHISTOGRAM
Undocumented ltutil.rowsInversFromHistogram(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
workspace_var   IN VARCHAR2,
beginver        IN NUMBER,
endver          IN NUMBER,
colname         IN VARCHAR2,
returnpercent   IN BOOLEAN)
RETURN NUMBER;
TBD
 
SEPARATECLOBINTO2PARTS
Protected by an ACCESSIBLE BY clause ltutil.separateClobInto2parts(
c   IN  CLOB,
s1  OUT VARCHAR2,
s2  OUT VARCHAR2,
len IN  NUMBER);
DECLARE
 inVal   CLOB := 'The Quick Brown Fox Jumped Over The Lazy Programmer';
 outVal1 dbms_id;
 outVal2 dbms_id;
BEGIN
  wmsys.ltutil.separateclobinto2parts(inVal, outVal1, outVal2, 10);
  dbms_output.put_line(outVal1);
  dbms_output.put_line(outVal2);
END;
/
 wmsys.ltutil.separateclobinto2parts(inVal, outVal1, outVal2, 10);
 *
ERROR at line 6:
ORA-06550: line 6, column 3:
PLS-00904: insufficient privilege to access object SEPARATECLOBINTO2PARTS
 
SETDEBUGOPTIONS
Undocumented ltutil.setDebugOptions(
debug_option IN VARCHAR2,
param1       IN VARCHAR2);
TBD
 
SETDISVER
Undocumented ltutil.setdisver(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
disver          IN VARCHAR2)
TBD
 
SETTXNSAVEPOINT
Creates a transaction save point. ltutil.settxnsavepoint;
exec wmsys.ltutil.settxnsavepoint;

PL/SQL procedure successfully completed.
 
SETVARIABLE
Undocumented ltutil.setvariable(
varname IN VARCHAR2,
value_r IN wmsys.ltutil.rowid_wct);
TBD
 
SKIPOBJECTSDURINGEXPORT
Undocumented ltutil.skipobjectsduringexport(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
fmode_v     IN VARCHAR2,
buffercode  IN BOOLEAN);
TBD
 
STRIPVERSION
Undocumented ltutil.stripVersion(
wm_nextver IN VARCHAR2,
curver     IN VARCHAR2,
noinsert   IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
STRIPVERSIONRANGE
Undocumented ltutil.stripVersionRange(
wm_nextver    IN VARCHAR2,
version_range IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
STUFFVERSION
Undocumented ltutil.stuffVersion(
wm_nextver IN VARCHAR2,
curver     IN NUMBER)
RETURN VARCHAR2;
TBD
 
STUFFVERSIONRANGE
Undocumented ltutil.stuffVersionRange(
wm_nextver    IN VARCHAR2,
version_range IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
SUBSVERSION
Undocumented ltutil.subsVersion(
wm_nextver IN VARCHAR2,
cur_vers   IN VARCHAR2,
subs_ver   IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
TOPOTABLECHECK
Undocumented ltutil.topoTableCheck(
table_owners IN wmsys.ltutil.wm$ident_tab,
table_names  IN wmsys.ltutil.wm$ident_tab,
fmode        IN VARCHAR2);
TBD
 
TO_CLOB_
Protected by an ACCESSIBLE BY clause ltutil.to_clob_(text IN VARCHAR2) RETURN CLOB;
DECLARE
 retVal CLOB;
BEGIN
  retVal := wmsys.ltutil.to_clob_('Test string');
  dbms_output.put_line(retVal);
END;
/
 retVal := wmsys.ltutil.to_clob_('Test string');
*
ERROR at line 4:
ORA-06550: line 4, column 13:
PLS-00904: insufficient privilege to access object TO_CLOB_
 
UPDATESDOTOPOMETADATADV
Undocumented ltutil.updateSDOtopometadatadv(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2);
TBD
 
UPDATESDOTOPOMETADATAEV
Undocumented ltutil.updateSDOtopometadataev(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2);
TBD
 
VT_FIXNVTAB
Undocumented ltutil.vt_fixnvtab(
sourcestate       IN VARCHAR2,
targetstate       IN VARCHAR2,
targetcurver      IN NUMBER,
tab_owner         IN VARCHAR2,
tab_name          IN VARCHAR2,
operation         IN VARCHAR2,
docrcheck         IN BOOLEAN,
mp_root_workspace IN VARCHAR2);
TBD
 
WM$CONCAT
Undocumented ltutil.wm$concat(strs IN wmsys.wm$ident_tab_type) RETURN CLOB;
TBD
 
WM$CONVERTVERSIONSTR
No reason to believe the demo at right is what was intended but it does give an indication of how it might be used ltutil.wm$convertversionstr(version_str IN VARCHAR2) RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$convertversionstr('19.3.0.0')
FROM dual;

WMSYS.LTUTIL.WM$CONVERTVERSIONSTR('19.3.0.0')
----------------------------------------------------
J.3.0.0

SELECT wmsys.ltutil.wm$convertversionstr('12.1.0.2')
FROM dual;

WMSYS.LTUTIL.WM$CONVERTVERSIONSTR('12.1.0.2')
----------------------------------------------------
C.1.0.2
 
WM$GETDBCOMPATIBLESTR
Protected by an ACCESSIBLE BY clause ltutil.wm$getdbcompatiblestr RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$getdbcompatiblestr
FROM dual;
SELECT wmsys.ltutil.wm$getdbcompatiblestr
       *
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object WM$GETDBCOMPATIBLESTR
 
WM$GETDBVERSIONSTR
Undocumented ltutil.wm$getdbversionstr RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$getdbversionstr
FROM dual;

WM$GETDBVERSIONSTR
-------------------
J.0.0.0.0
 
WM$GETERRORS
Undocumented ltutil.wm$geterrors RETURN wmsys.wm$exp_map_tab;
TBD
 
WM$SORTSTRING
This is an amazing function. Given a delimited string and the delimiting character it alpha sorts the values and returns them with the same delimiter. ltutil.wm$sortstring(
str       IN VARCHAR2,
delimiter IN VARCHAR2)
RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$sortstring('A|Z|B|Y|C|X', '|')
FROM dual;

WMSYS.LTUTIL.WM$SORTSTRING('A|Z|B|Y|C|X','|')
----------------------------------------------
A|B|C|X|Y|Z
 
WRITETOLOG
Undocumented

Overload 1		 ltutil.writeToLog(str IN VARCHAR2);
exec wmsys.ltutil.writeToLog('Test Write');
BEGIN wmsys.ltutil.writeToLog('Test Write'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object WRITETOLOG
Undocumented

Overload 2		 ltutil.writeToLog(cstr IN CLOB);
TBD
 
WRITEUNDOCODE
Undocumented

Overload 1		 ltutil.writeUndoCode(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
undocode        IN VARCHAR2,
index_type_var  IN NUMBER,
execuser        IN VARCHAR2);
TBD
Undocumented

Overload 2		 ltutil.writeUndoCode(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
undocode        IN CLOB,
index_type_var  IN NUMBER,
execuser        IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WM
LT
LTAQ
LTDDL
LTDTRG
LTI
LTPRIV
LTRIC
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_MP_PKG
OWM_VSCRIPT_PKG
OWM_VT_PKG
WM_DDL_UTIL
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-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx