Oracle | LTDEFINER

Oracle LTDEFINER Version 23c

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 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 23c

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/owmsyss.plb
{ORACLE_HOME}/rdbms/admin/owmsysb.plb

Subprograms

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

EXECSQL

Undocumented

Protected by an ACCESSIBLE BY clause ltdefiner.execSQL(sqlstr IN VARCHAR2);

conn wmsys

      password:

      

      exec ltdefiner.execSQL('GRANT dba TO scott');

             *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object EXECSQL

STUFFVERSION

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);

             *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object STUFFVERSION