Oracle | LTADM

Oracle LTADM 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 = 'LTADM' UNION SELECT referenced_name FROM dba_dependencies where name = 'LTADM' ORDER BY 1; Returns 73 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/owmadms.plb
{ORACLE_HOME}/rdbms/admin/owmadmb.plb
{ORACLE_HOME}/rdbms/admin/owmr1120.plb
{ORACLE_HOME}/rdbms/admin/owmr1210.plb
{ORACLE_HOME}/rdbms/admin/owmr1220.plb

Subprograms

ACQUIRELOCKONRESOURCE	EXECSQLAUTO	ISLOCKINGALIVE
ACQUIRELOCKS	EXECSQLFROMCLOB	ISVERSIONEDTABLE
ADDEVUNDOCODE	EXECSQLINTOINT	LOGSESSIONINWS
ADDLOCKROWSINFOENTRY	EXECSQLINTOSTR	NO_VM_ALTER_PROC
ADDVERSIONEDTABLE	EXECSQLWUNDO (2)	NO_VM_CREATE_PROC
ALTERSAVEPOINT	EXISTCONFLICTS	NO_VM_DROP_PROC
ALTERSTATE	EXISTOPENSHORTTRANSINSTATE	NUMACTIVESESSIONS
APPLY_UNIQUE_CONSTRAINTS	EXISTSOPENSHORTTRANS	OPENCURSOR (5)
ARETHERECONFLICTS	EXISTSOPENSHORTTRANSONTABLE	POSTTABLE_RIC
ARETHEREDIFFS	EXISTSSAVEPOINT	REFRESHCURRENTMPLEAFS
BEGINRESOLVE	EXISTSSTATE	REFRESHSTATE_INTERNAL
BUILD_MODIFIED_TABLES_LIST	FREEZESTATE	REFRESHSYSTEMPARAMETERS
CHECKFORADDITIONALROWS	GETALLRESOLVESTATUS	REFRESHTABLE
CHECKWHERECLAUSE	GETALLSTATEATTRIBUTES	RELEASELOCK
CHECK_FOR_NVE_CHILD_TABLES	GETANCESTORWORKSPACE	RELEASELOCKS
CHILD_TABLES_EXIST	GETCOLALIASES	RELEASEWSPRESENCELOCKS
CLEANUPAUXTABLE	GETINSTEADOFDELTRIGNAME	REMOVESTATE
CLEANUPMODTABLE	GETINSTEADOFINSTRIGNAME	RESETCRSTATUS
CLEANUP_MW_TABLE	GETINSTEADOFUPDTRIGNAME	RESOLVETABLENAME
COMPRESSSTATE	GETLOCKWITHSTATUS	REVOKESTATEPRIV
COMPRESSSTATE_INTERNAL	GETRESOLVESTATUS	REVOKESYSTEMPRIV
COMPUTERICWEIGHT	GETSPVERSION	ROLLBACKRESOLVE
COPYTABLE	GETSTATEATTRIBUTES	ROLLBACKTABLE_PARTIAL
COPYTABLE_VT	GETSTATELOCKID	SETOLDPRESENCELOCKS
CREATESAVEPOINT	GETSYSTEMPARAMETER	SETSTATELOCKMODEOFF
CREATESTATE	GETWORKSPACECURVER	SETSTATELOCKMODEON
CURRENTUSERSSESSION	GETWORKSPACEDEPTH	SETSYNCPARVER
DELETETABLE_INTERNAL	GETWORKSPACESYSTEMMODE	SETSYSTEMPARAMETER
DELETETABLE_INTERNAL_VT	GOTODATE	TURNONPESSIMISTICLOCKING
DISABLESYSTEMTRIGGERS	GOTOTS	UNFREEZESTATE
DISABLESYSTEMTRIGGERS_EXP	GRANTSTATEPRIV	UPDATECRSTATUS
ENABLESYSTEMTRIGGERS	GRANTSYSTEMPRIV	UPDATEVERSIONEDTABLE
ENDRESOLVE	INSERT_INTO_MODIFIED_TABLES	VERSIONROWCOPY
EXECSQL	INSERT_INTO_MW_TABLE

ALTERSAVEPOINT

Undocumented ltadm.algterSavePoint( state IN VARCHAR2, sp_name IN VARCHAR2, sp_description IN VARCHAR2);

TBD

CHECKWHERECLAUSE

Undocumented ltadm.checkWhereClause( owner_var IN VARCHAR2, table_name_var IN VARCHAR2, where_clause IN VARCHAR2, pkey_cols OUT VARCHAR2);

TBD

CREATESAVEPOINT

Undocumented ltadm.createSavePoint( savepoint_name IN VARCHAR2, sp_state IN VARCHAR2, sp_status IN NUMBER, sp_version IN OUT NUMBER, sp_owner IN VARCHAR2, sp_desc IN VARCHAR2, requestnewversion IN BOOLEAN, opcode IN VARCHAR2) RETURN NUMBER;

TBD

CURRENTUSERSSESSION

Undocumented

Protected by an Accessible By clause ltadm.currentUserSession(l_owner IN VARCHAR2) RETURN BOOLEAN;

conn wmsys/wmsys

      

      BEGIN

        IF ltadm.currentUserSession(USER) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      ERROR at line 2:

      ORA-06550: line 2, column 6:

      PLS-00904: insufficient privilege to access object LTADM

EXECSQL

Undocumented

Overload 1 ltadm.execSQL(sqlstr IN VARCHAR2);

TBD

Overload 2 ltadm.execSQL( sqlstr IN VARCHAR2, param1 IN VARCHAR2);

TBD

Overload 3 ltadm.execSQL( sqlstr IN VARCHAR2, param1 IN VARCHAR2, param2 IN VARCHAR2);

TBD

Overload 4 ltadm.execSQL( sqlstr IN VARCHAR2, param1 IN VARCHAR2, param2 IN VARCHAR2, param3 IN VARCHAR2);

TBD

Overload 5 ltadm.execSQL( sqlstr IN VARCHAR2, param1 IN NUMBER, param2 IN NUMBER, param3 IN NUMBER, param4 IN NUMBER);

TBD

Overload 6 ltadm.execSQL( sqlstr IN VARCHAR2, param1 IN VARCHAR2, param2 IN VARCHAR2, param3 IN NUMBER, param4 IN NUMBER, param5 IN NUMBER, param6 IN NUMBER);

TBD

Overload 7 ltadm.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

EXECSQLAUTO

Undocumented

Overload 1

Protected by an Accessible By clause ltadm.execSqlAuto(sqlstr IN VARCHAR2);

conn wmsys/wmsys

      

      exec ltadm.execSqlAuto('SELECT dummy FROM dual');

          
      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object LTADM

Overload 2 ltadm.execSqlAuto( sqlstr IN VARCHAR2, param1 IN VARCHAR2);

TBD

Overload 3 ltadm.execSqlAuto( sqlstr IN VARCHAR2, param1 IN VARCHAR2, param2 IN VARCHAR2);

TBD

EXECSQLFROMCLOB

Undocumented ltadm.execSqlFromCLOB( cstr IN CLOB, compress_flag IN BOOLEAN);

TBD

EXECSQLINTOINT

Undocumented

Overload 1 ltadm.execSqlIntoInt( sqlstr IN VARCHAR2, retval OUT NUMBER);

TBD

Overload 2 ltadm.execSqlIntoInt( sqlstr IN VARCHAR2, retval OUT NUMBER, param1 IN VARCHAR2);

TBD

Overload 3 ltadm.execSqlIntoInt( sqlstr IN VARCHAR2, retval OUT NUMBER, param1 IN VARCHAR2, param2 IN VARCHAR2);

TBD

Overload 4 ltadm.execSqlIntoInt( sqlstr IN VARCHAR2, retval OUT NUMBER, param1 IN VARCHAR2, param2 IN VARCHAR2, param3 IN VARCHAR2);

TBD

EXECSQLINTOSTR

Undocumented

Overload 1 ltadm.execSqlIntoStr( sqlstr IN VARCHAR2, retval OUT VARCHAR2);

TBD

Overload 2 ltadm.execSqlIntoStr( sqlstr IN VARCHAR2, retval OUT VARCHAR2, param1 IN VARCHAR2);

TBD

GOTODATE

Undocumented ltadm.goToDate( instant IN DATE, curstate IN VARCHAR2);

TBD

GRANTSTATEPRIV

Undocumented ltadm.grantStatePriv( in_grantee IN VARCHAR2, priv_type IN VARCHAR2, in_state IN VARCHAR2, in_grantor IN VARCHAR2, admin_option IN NUMBER);

TBD

GRANTSYSTEMPRIV

Undocumented ltadm.grantSystemPriv( in_grantee IN VARCHAR2, priv_type IN VARCHAR2, in_grantor IN VARCHAR2, admin_option IN NUMBER);

TBD

ISVERSIONEDTABLE

Undocumented ltadm.isVersionedTable( schema_name IN VARCHAR2, tab_name IN VARCHAR2) RETURN BOOLEAN;

TBD

RELEASELOCKS

Undocumented ltadm.releaseLocks(locked_wspcs IN wmsys.ltutil.number_tab_bin);

TBD

RESOLVETABLENAME

Undocumented ltadm.resolveTableName( schemaname IN OUT VARCHAR2, tablename IN OUT VARCHAR2, only_versioned IN BOOLEAN) RETURN BOOLEAN;

TBD

SETSYSTEMPARAMETER

Undocumented ltadm.setSystemParameter( p_name IN VARCHAR2, p_value IN VARCHAR2);

TBD