Oracle | LTADM

Oracle LTADM 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 Undocumented Workspace Management internal utilities.

AUTHID DEFINER

Dependencies

ALL_CONS_COLUMNS	LTUTIL	WM$MP_PARENT_WORKSPACES_TABLE$
ALL_IND_COLUMNS	LT_CTX_PKG	WM$MW_TABLE
ALL_TABLES	LT_EXPORT_PKG	WM$MW_TABLE$
ALL_TAB_COLS	OBJ$	WM$NESTED_COLUMNS_TABLE
ALL_USERS	OWM_ASSERT_PKG	WM$NEXTVER_EXP_TAB_TYPE
ALL_WORKSPACE_PRIVS	OWM_BULK_LOAD_PKG	WM$NEXTVER_TABLE
COL$	OWM_DDL_PKG	WM$NV_PAIR_NT_TYPE
COLTYPE$	OWM_DML_PKG	WM$NV_PAIR_TYPE
DBA_CONSTRAINTS	OWM_DYNSQL_ACCESS	WM$OPER_LOCKVALUES_ARRAY_TYPE
DBA_INDEXES	OWM_IEXP_PKG	WM$OPER_LOCKVALUES_TYPE
DBA_LOBS	OWM_MIG_PKG	WM$RESOLVE_WORKSPACES_TABLE
DBA_ROLES	OWM_MP_PKG	WM$RESOLVE_WORKSPACES_TABLE$
DBA_SEGMENTS	OWM_VT_PKG	WM$RIC_TABLE
DBA_TABLES	PLITBLM	WM$RIC_TRIGGERS_TABLE
DBA_TAB_COLS	UD_TRIGS	WM$SYSPARAM_ALL_VALUES
DBA_TRIGGERS	V$LOCK	WM$UDTRIG_DISPATCH_PROCS
DBA_VIEWS	V$OBJECT_DEPENDENCY	WM$UDTRIG_INFO
DBMS_AQADM	V$OPEN_CURSOR	WM$VERSIONED_TABLES
DBMS_LOB	V$SESSION	WM$VERSIONED_TABLES$
DBMS_LOCK	V$SQL	WM$VERSIONED_TABLES$H
DBMS_SESSION	V$TRANSACTION	WM$VERSION_HIERARCHY_TABLE
DBMS_SQL	WM$BATCH_COMPRESSIBLE_TABLES	WM$VERSION_TABLE
DBMS_STANDARD	WM$CONSTRAINTS_TABLE	WM$VTID
DBMS_UTILITY	WM$DBA_TAB_COLS	WM$WORKSPACES_TABLE
DUAL	WM$ED_UNDO_CODE_TABLE_TYPE	WM$WORKSPACES_TABLE$
GV$LOCKED_OBJECT	WM$ENV_VARS	WM$WORKSPACES_TABLE$D
GV$SESSION	WM$INSTEADOF_TRIGS_TABLE	WM$WORKSPACE_PRIV_TABLE
LT	WM$LOCKROWS_INFO	WM$WORKSPACE_SAVEPOINTS_TABLE
LTAQ	WM$LOCK_SEQUENCE	WM$WORKSPACE_SESSIONS_VIEW
LTDDL	WM$MODIFIED_TABLES	WM_DDL_UTIL
LTDTRG	WM$MODIFIED_TABLES$	WM_ERROR
LTPRIV	WM$MP_GRAPH_WORKSPACES_TABLE	WM_EVENTS_INFO
LTRIC	WM$MP_PARENT_WORKSPACES_TABLE	WM_PERIOD

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted

This package is protected 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;

      /

       IF ltadm.currentUserSession(USER) THEN

      *

      ERROR at line 2:

      ORA-06550: line 2, column 6:

      PLS-00904: insufficient privilege to access object LTADM

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

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

      BEGIN ltadm.execSqlAuto('SELECT dummy FROM dual'); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object LTADM

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

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