Oracle LTDEFINER
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Undocumented Workspace Management internal utilities.
AUTHID DEFINER
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'LTDEFINER'
UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'LTDEFINER'
ORDER BY 1;

Returns 138 rows.
Documented No
First Available 23ai
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/owmsyss.plb
{ORACLE_HOME}/rdbms/admin/owmsysb.plb
Subprograms
ADDASPARENTWORKSPACE_SQL1 GRANTOLSPRIVS
ADDASPARENTWORKSPACE_SQL2 GRANTPRIVSADMIN
ADDASPARENTWORKSPACE_SQL3 (2 overloads) GRANTSTATEPRIV
ADDASPARENTWORKSPACE_SQL4 GRANTSYSTEMPRIV
ADDLOCKROWSINFOENTRY_SQL1 GRANT_EXP_MAP
ADDVALIDTIMESUPPORT_SQL1 GRANT_SELECT
ADDVERSIONEDTABLE HASCRCHILD
ALTERSAVEPOINT HASDEFERREDCHILD
ALTERSTATE HASNESTEDTABLECOLUMN
APPLY_RIC_RESTRICT_SQL1 HASOLSPOLICY
APPLY_RIC_RESTRICT_SQL2 HASRICCASCADINGCONSTRAINT
BEGINBULKLOADING_SQL1 HASRICSETNULLCONSTRAINT
BEGINBULKLOADING_SQL2 HASSYSPRIV
BEGINRESOLVE_SQL1 HISTWITHDATETYPEEV
BEGINRESOLVE_SQL2 HIST_FROM_WMSYS
CHANGEWORKSPACETYPE_CURSOR IMP_COPY_B_COMPRESS_TABLE
CHECKCONSTRAINTENFORCESNOTNULL IMP_COPY_CONS_COLS
CHECKDELTOPOGEOLAYERERRORS_SQL1 IMP_COPY_CONS_TABLE
CHECKFORERRORSEV IMP_COPY_ENV_VARS
CHECKFORERRORSEV_SQL1 IMP_COPY_EVENTS_INFO
CHECKRICONRFRSHBYFLIPPING_SQL1 IMP_COPY_EXP_MAP
CHECKRICONRFRSHBYFLIPPING_SQL2 IMP_COPY_HINT_TABLE
CHECKWHERECLAUSE_SQL1 IMP_COPY_LOCKROWS_INFO
CHECKWSPCFREEZECOMPAT_SQL IMP_COPY_METADATA_MAP (2 overloads)
CHECK_CONSTRAINT_PK IMP_COPY_MODIFIED_TABLE
CHECK_FOR_NVE_CHILD_TABLES IMP_COPY_MP_GRAPH_WS_TABLE
CHECK_MRIC_CASCADE IMP_COPY_MP_PARENT_WS_TABLE
CLEANTEMPTABLES IMP_COPY_NESTED_COL_TABLE
CLEANUPDV_WMSYS IMP_COPY_NEXTVER_TABLE
CLEANUPENDBULKLOADING_SQL5 IMP_COPY_RESOLVE_WS_TABLE
CLEANUPLOCKROWSINFO IMP_COPY_RIC_LOCK_TABLE
CLEANUPMODTABLE IMP_COPY_RIC_TABLE
CLEANUPSTALEMETADATA IMP_COPY_RIC_TRIG_TABLE
COMPRESSBRANCH_SQL1 IMP_COPY_UDTRIG_DISP_PROCS
COMPRESSBRANCH_SQL2 IMP_COPY_UDTRIG_INFO
COMPRESSBRANCH_SQL3 IMP_COPY_VER_HIER_TABLE
COMPRESSBRANCH_SQL4 IMP_COPY_VER_TABLE
COMPRESSBRANCH_SQL5 IMP_COPY_VT_ERRORS_TABLE
COMPRESSBRANCH_SQL6 IMP_COPY_WS_PRIV_TABLE
COMPRESSBRANCH_SQL7 IMP_COPY_WS_SP_TABLE
COMPRESSBRANCH_TABLE_BATCH_SQL1 IMP_COPY_WS_TABLE
COMPRESSBRANCH_TABLE_BATCH_SQL2 IMP_EXP_ENV_VAR_SQL1
COMPRESSBRANCH_TABLE_BATCH_SQL3 INDEXCREATEDBYCONSTRAINT
COMPRESSBRANCH_TABLE_BATCH_SQL4 INDEXWILLBEDROPPED
COMPRESSSTATE_INTERNAL_SQL1 INITIALIZE_IMPORT_SQL1
COMPRESSSTATE_INTERNAL_SQL2 INITVARIABLES_SQL1
COMPRESSSTATE_SQL1 INSERTCRNEXTVERS
COMPRESSWORKSPACE_RECURSIVE_SQL1 INSERTFULLROLLBACKMARKER
CREATEIMPLICITSPINGRAPH_SQL1 INSERTNEXTVERS
CREATEINLISTFROMQUERY INSERTNONCRNEXTVERS_SQL1
CREATERICLOCKINGTABLES INSERTVERSION (2 overloads))
CREATESAVEPOINT_SQL1 (2 overloads) INSERT_ERRORS_TABLE
CREATESAVEPOINT_SQL2 INSERT_HINT_TABLE
CREATESAVEPOINT_SQL3 INSERT_INTO_ERRORS_TABLE
CREATESAVEPOINT_SQL4 INSERT_INTO_MODIFIED_TABLES
CREATESAVEPOINT_SQL5 INSERT_INTO_MW_TABLE
CREATESAVEPOINT_SQL6 INSERT_MODIFIED_TABLES
CREATESAVEPOINT_SQL7 INSERT_UDTRIG_DISPATCH_PROCS
CREATESAVEPOINT_SQL8 INSERT_UDTRIG_INFO
CREATESAVEPOINT_SQL9 INSERT_UDTRIG_INFO_2
CREATESTATE_SQL1 INVERSIONEDSTATE
CREATESTATE_SQL2 ISBEINGRESOLVED
CREATESTATE_SQL3 ISIMPLICITSP
CREATESTATE_SQL4 ISLEAFSTATE
CREATETEMPTABLES ISLOCKINGALIVE
DELETESAVEPOINT_INTERNAL_SQL1 ISMODIFIED
DELETEUNDOCODE ISMPWORKSPACE
DELETEUNDOCODERANGE ISSPLITINSUBTREE
DELETE_ERRORS_TABLE ISVERSIONEDSTAGINGTABLE
DELETE_FROM_ERRORS_TABLE ISVERSIONEDTABLE
DELETE_UDTRIG_DISPATCH_PROCS ISVERSIONEDTABLE_VER_VAR
DELETE_UDTRIG_INFO ISVERSIONENABLEDTOPOLOGY
DELETE_UDTRIG_INFO_2 ISWORKSPACEOWNER
DISABLESYSTEMTRIGGERS IS_RIC_CHILD_OF_ENABLED_TABLE
DISALLOWIFWITHVT IS_RIC_PARENT
DROPRICLOCKINGTABLES LOCKALLWORKSPACES_SQL1
DROP_EXP_MAP LOCKGRAPH
ENABLESYSTEMTRIGGERS LOCKTABLEVERSIONTABLE
ENDBULKLOADING_SQL1 LOCKWORKSPACETREE_SQL1
ENDRESOLVE LTUTIL_GETWORKSPACELOCKID
ENFORCEUNIQUECONSTRAINTS_SQL1 MOVEWMMETADATA_SQL1
ENFORCEUNIQUECONSTRAINTS_SQL2 NUMACTIVESESSIONS
ENFORCEUNIQUECONSTRAINTS_SQL3 PK_CONSTRAINT_NAME_FROM_WMSYS
ERRORLOGTABLE POSTTABLE_INTERNAL_MULTI_SQL1
EXECEVUNDO_SQL1 POSTWORKSPACE_INTERNAL_SQL1
EXECSQL RBCKWSPC_COMMON_INTERNAL_SQL1
EXECSQLAUTO (3 overloads) REFRESHCURRENTMPLEAFS
EXECSQLFROMCLOB REFRESHMPGRAPH_SQL1
EXECSQLINTOINT (4 overloads) REFRESHREFRESHEDSTATES
EXECSQLINTOSTR (2 overloads) REFRESHSTATE_FIXVERSIONS
EXISTOPENSHORTTRANSINSTATE_SQL1 REFRESHSTATE_INTERNAL_SQL1
EXISTOPENSHORTTRANSINSTATE_SQL2 REFRESHSYSTEMPARAMETERS_SQL1
EXISTSFULLROLLBACKMARKER REFRESHWORKSPACE_WRT_PARENT_SQL1
EXISTSMPWORKSPACE RELEASELOCKS_SQL1
EXISTSOPENSHORTTRANS RELEASEWSPRESENCELOCKS_SQL1
EXISTSOPENSHORTTRANSONTABLE RELRICSESSLOCKSFORTABLE_SQL1
EXISTSSAVEPOINT REMOVEASPARENTWORKSPACE_SQL1
EXISTSSTATE REMOVEASPARENTWORKSPACE_SQL2
FINDFETCHLIMIT REMOVEASPARENTWORKSPACE_SQL3
FINDRICSET_SQL1 REMOVEASPARENTWORKSPACE_SQL4
FINDRICSET_SQL2 REMOVEASPARENTWORKSPACE_SQL5
FINDRICSET_SQL3 REMOVEDEFERREDWORKSPACES_I_SQL1
FINDRICSET_SQL4 REMOVELOCKS_LOCKROWS_SQL1
FIXCONSTRAINTSEV REMOVELOCKS_LOCKROWS_SQL2
FIXINDEXEV REMOVELOCKS_LOCKROWS_SQL3
FIXPKCONSTRAINT_SQL1 REMOVESTATE
FIXPKCONSTRAINT_SQL2 REMOVEUSERDEFINEDHINT
FIXPRIVSEV_SQL1 REMOVEWORKSPACE_INTERNAL_SQL1
FIXPRIVSEV_SQL2 REMOVEWORKSPACE_REC_INTERNAL_SQL1
FIXVTAB_REFRESH RENAMECOLS_SQL1
FREEZESTATE RENAMEINDEX_SQL1
GARBAGE_COLLECT_MOD_TABS RENAMESAVEPOINT
GENDIRTYROWSWC_SQL1 RENAMEWORKSPACE_SQL1
GETALLRESOLVESTATUS RESETCRSTATUS
GETALLSTATEATTRIBUTES RESETGRAPHPOSTVERSION
GETANCESTORWORKSPACE RESOLVESYNONYM
GETASSOCIATEDINDEX RESTARTSEQUENCE
GETBASETABLENAME REVOKESTATEPRIV
GETBOUNDEDBLOCKSPERBATCH REVOKESYSTEMPRIV
GETCOLINFO_SQL0 RIC_TOPO_TABLE_REFS_SQL1
GETCOLINFO_SQL1 ROLLBACKBULKLOADING_SQL1
GETCOLUMNPLUSEXPRESSION ROLLBACKDDL_SQL1
GETCONTAINEDVERINRANGE ROLLBACKRESOLVE
GETCURRENTLOCKINGMODE ROLLBACKWORKSPACE_INTERNAL_SQL1
GETDISVER SELECT_CNT_FROM_ERRORS_TABLE
GETGRAPHNODES_SQL1 SELECT_FROM_ERRORS_TABLE
GETHISTOPTION SETCONTEXTVARSFORREMOVE
GETINDEXCLAUSE SETDISVER
GETINDEXCOLUMNS SETLOCKINGON_SQL1
GETINDEXSUBCLAUSE SETRICWEIGHT
GETLOCKMODE SETSTATELOCKMODEOFF
GETMAXBLOCKSIZE SETSTATELOCKMODEON
GETMINWORKSPACEVERSION SETSYNCPARVER
GETMODVER SKIPOLSCOLUMN
GETMWVIEW STICKQUALIFIER_SQL1
GETNCA STUFFVERSION
GETNESTEDTABLEMETADATACOLUMNS STUFFVERSIONRANGE
GETNEXTVERSION SYNCINDEXES_SQL1
GETNOTNULLCONSTRAINT SYNCOLSPOLICIES
GETPKEYCOLS_SQL1 (2 overloads) TRANSFERNTINDEXESDV_SQL1
GETRESOLVESTATUS TRANSFERNTINDEXESEV_SQL1
GETRICSTATUS TRANSFEROLSPOLICIES
GETROOT TURNONPESSIMISTICLOCKING
GETSPACEUSAGE UDTRIG_INFO
GETSPVERSION UNFREEZESTATE
GETSTATEATTRIBUTES UPDATECRSTATUS
GETSTATELOCKID UPDATEMODIFIEDTABLESLIST_SQL1
GETSTATELOCKIDS UPDATEMPGRAPHS
GETSYSTEMPARAMETER UPDATERICCONSNAME
GETTABLEINDEXES UPDATEROOTANCVERSIONS
GETTABLEPROPERTYDIFFS_SQL1 UPDATE_DISPATCH_PROCS
GETTOPOINFO UPDATE_ERRORS_TABLE
GETTRIGNO UPDATE_ERRORS_TABLE_2
GETUCSFROMSKELETONTABLE_SQL1 UPDATE_ERRORS_TABLE_3
GETUCSFROMSKELETONTABLE_SQL2 UPDATE_HINT_TABLE
GETUCSFROMSKELETONTABLE_SQL3 UPDATE_UDTRIG_DISPATCH_PROCS
GETUCSFROMSKELETONTABLE_SQL4 UPDATE_UDTRIG_DISPATCH_PROCS_2
GETUCSFROMSKELETONTABLE_SQL5 UPDATE_UDTRIG_INFO
GETUCSFROMSKELETONTABLE_SQL6 UPDATE_UDTRIG_INFO_FLAG
GETUCSFROMSKELETONTABLE_SQL7 UPDATE_UDTRIG_INFO_FLAG_2
GETUCSFROMSKELETONTABLE_SQL8 UPDATE_UDTRIG_INFO_FLAG_3
GETUCSFROMSKELETONTABLE_SQL9 UPDATE_UDTRIG_INFO_FLAG_4
GETUCSFROMSKELETONTABLE_SQL10 VALIDATESYSTEMSETTING_SQL1
GETUCSFROMSKELETONTABLE_SQL11 VALIDATESYSTEMSETTING_SQL2
GETUNDOCODECLOB VALIDATESYSTEMSETTING_SQL3
GETUNDOCODECLOBRANGE VALIDATESYSTEMSETTING_SQL4
GETUNIQUECHECKSTRPROC_SQL1 VALIDATESYSTEMSETTING_SQL5
GETVALIDTIMEOPTION VALIDATESYSTEMSETTING_SQL6
GETVN VALIDATESYSTEMSETTING_SQL7
GETVTID VALIDATESYSTEMSETTING_SQL8
GETWORKSPACECURVER VALIDATESYSTEMSETTING_SQL9
GETWORKSPACEDEPTH VALIDATE_CONSTRAINTS_SQL1
GETWORKSPACELOCKID VALIDATE_CONSTRAINTS_SQL2
GETWORKSPACELOCKMODE VERIFYTABLECOLUMNS
GETWORKSPACESYSTEMMODE_SQL1 VERIFYTABLEPK_SQL1
GET_CONSTRAINT_STATUS VERIFYTABLEPK_SQL2
GET_CONS_COL_POSITION VERSIONROWCOPY_SQL1
GET_DISPATCH_PROCS_REC VERTABS_FROM_VERSIONED_TABLES
GET_E_EXP_MAP WMRIC_SET_IN_CNT
GET_UDTRIG_DISPATCHER_SEQUENCE_VALUE WRITEUNDOCODE_COMMON
GOTODATE  
 
EXECSQL (new 23ai)
Undocumented

Protected by an ACCESSIBLE BY clause

Overload 1		 ltdefiner.execSQL(sqlstr IN VARCHAR2);
conn wmsys
password:

exec wmsys.ltdefiner.execSQL('GRANT dba TO scott');
     *
PLS-00904: insufficient privilege to access object EXECSQL
Overload 2 ltdefiner.execSQL(
sqlstr IN VARCHAR2,
param1 IN VARCHAR2);
TBD
Overload 3 ltdefiner.execSQL(
sqlstr IN VARCHAR2,
param1 IN VARCHAR2,
param2 IN VARCHAR2);
TBD
Overload 4 ltdefiner.execSQL(
sqlstr IN VARCHAR2,
param1 IN VARCHAR2,
param2 IN VARCHAR2,
param3 IN VARCHAR2);
TBD
Overload 5 ltdefiner.execSQL(
sqlstr IN VARCHAR2,
param1 IN VARCHAR2,
param2 IN VARCHAR2,
param3 IN VARCHAR2,
param4 IN VARCHAR2);
TBD
Overload 6 ltdefiner.execSQL(
sqlstr IN VARCHAR2,
param1 IN VARCHAR2,
param2 IN VARCHAR2,
param3 IN VARCHAR2,
param4 IN VARCHAR2,
param5 IN VARCHAR2,
param6 IN VARCHAR2);
TBD
Overload 7 ltdefiner.execSQL(
sqlstr IN VARCHAR2,
param1 IN VARCHAR2,
param2 IN VARCHAR2,
param3 IN VARCHAR2,
param4 IN VARCHAR2,
param5 IN VARCHAR2,
param6 IN VARCHAR2,
param7 IN VARCHAR2,
param8 IN VARCHAR2);
TBD
 
STUFFVERSION (new 23ai)
Undocumented

Protected by an ACCESSIBLE BY clause		 ltdefiner.stuffversion(
wm_nextver IN VARCHAR2,
curver     IN NUMBER)
RETURN VARCHAR2;
conn wmsys
password:

SELECT wmsys.ltdefiner.stuffversion('27', 23);
       *
ORA-06553: PLS-904: insufficient privilege to access object STUFFVERSION

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WM
LT
LTADM
LTAQ
LTDDL
LTDTRG
LTRIC
WM_DDL_UTIL
WM_ERROR
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved