Oracle LTDEFINER
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 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