Oracle LTI
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 CURRENT_USER
Dependencies
ALL_MP_PARENT_WORKSPACES LTPRIV ROLE_TAB_PRIVS
ALL_TABLES LTRIC SESSION_PRIVS
ALL_TAB_PRIVS_RECD LTUTIL SESSION_ROLES
ALL_VIEWS LT_CTX_PKG USER_SYS_PRIVS
ALL_WORKSPACE_SAVEPOINTS OWM_ASSERT_PKG USER_VIEWS
DBMS_STANDARD OWM_BULK_LOAD_PKG USER_WM_PRIVS
DUAL OWM_IEXP_PKG USER_WORKSPACES
LT OWM_MP_PKG WM$NV_PAIR_NT_TYPE
LTADM OWM_VSCRIPT_PKG WM$NV_PAIR_TYPE
LTAQ PLITBLM WM_ERROR
LTDEFINER ROLE_SYS_PRIVS  
Documented No
First Available 20c
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/owmltis.plb
Subprograms
ADDASPARENTWORKSPACE GRANTSYSTEMPRIV REVOKEGRAPHPRIV
CHANGEWORKSPACETYPE GRANTWORKSPACEPRIV REVOKESYSTEMPRIV
CHECKTABLEPRIVS HASWMADMIN REVOKEWORKSPACEPRIV
CHECKWHERECLAUSE IMPORT ROLLBACKTABLE
COMPRESSWORKSPACE MERGETABLE ROLLBACKTOSP
COMPRESSWORKSPACETREE MERGEWORKSPACE ROLLBACKWORKSPACE
CREATESAVEPOINT REFRESHTABLE ROLLBACKWORKSPACE_INTERNAL
CREATEWORKSPACE REFRESHWORKSPACE SETACTIVETSFORDML
DELETESAVEPOINT REMOVEASPARENTWORKSPACE SETCONFLICTWORKSPACE_INTERNAL
EXPORT REMOVEDEFERREDWORKSPACES SETWORKSPACELOCKMODEOFF
GOTOWORKSPACE_INTERNAL REMOVEWORKSPACE SETWORKSPACELOCKMODEON
GRANTGRAPHPRIV REMOVEWORKSPACETREE  
 
ADDASPARENTWORKSPACE
Undocumented lti.addAsParentWorkspace(
workspace        IN VARCHAR2,
parent_workspace IN VARCHAR2)
Protected by an ACCESSIBLE BY clause
 
CHANGEWORKSPACETYPE
Undocumented lti.changeWorkspaceType(
workspace      IN VARCHAR2,
workspace_type IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
CHECKTABLEPRIVS
Undocumented lti.checkTablePrivs(
towner  IN VARCHAR2,
tabname IN VARCHAR2)
RETURN BOOLEAN;
Protected by an ACCESSIBLE BY clause
 
CHECKWHERECLAUSE
Undocumented lti.checkWhereClause(
owner_var      IN     VARCHAR2,
table_name_var IN     VARCHAR2,
where_clause   IN OUT VARCHAR2,
st_owner_v     IN     VARCHAR2,
st_name_v      IN     VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
COMPRESSWORKSPACE
Undocumented lti.compressWorkspace(
workspace                  IN VARCHAR2,
compress_view_wo_overwrite IN BOOLEAN,
firstsp                    IN VARCHAR2,
secondsp                   IN VARCHAR2,
auto_commit                IN BOOLEAN,
commit_in_batches          IN BOOLEAN,
batch_size                 IN VARCHAR2,
remove_latest_deleted_rows IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
COMPRESSWORKSPACETREE
Undocumented lti.compressWorkspaceTree(
workspace                  IN VARCHAR2,
compress_view_wo_overwrite IN BOOLEAN,
auto_commit                IN BOOLEAN,
commit_in_batches          IN BOOLEAN,
batch_size                 IN VARCHAR2,
remove_latest_deleted_rows IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
CREATESAVEPOINT
Undocumented lti.createSavepoint(
workspace      IN VARCHAR2,
savepoint_name IN VARCHAR2,
description    IN VARCHAR2)
Protected by an ACCESSIBLE BY clause
 
CREATEWORKSPACE
Undocumented lti.createWorkspace(
workspace   IN VARCHAR2,
isrefreshed IN BOOLEAN,
description IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
DELETESAVEPOINT
Undocumented lti.deleteSavepoint(
workspace                  IN VARCHAR2,
savepoint_name             IN VARCHAR2,
compress_view_wo_overwrite IN BOOLEAN,
auto_commit                IN BOOLEAN,
commit_in_batches          IN BOOLEAN,
batch_size                 IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
EXPORT
Undocumented lti.export(
table_name              IN VARCHAR2,
staging_table           IN VARCHAR2,
workspace               IN VARCHAR2,
where_clause            IN VARCHAR2,
export_scope            IN VARCHAR2,
after_savepoint_name    IN VARCHAR2,
as_of_savepoint_name    IN VARCHAR2,
after_instant           IN DATE,
as_of_instant           IN DATE,
versioned_db            IN BOOLEAN,
overwrite_existing_data IN BOOLEAN,
auto_commit             IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
GOTOWORKSPACE_INTERNAL
Undocumented lti.gotoWorkspace_internal(state IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GRANTGRAPHPRIV
Undocumented lti.grantGraphPriv(
priv_types     IN VARCHAR2,
leaf_workspace IN VARCHAR2,
grantee        IN VARCHAR2,
node_types     IN VARCHAR2,
grant_option   IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GRANTSYSTEMPRIV
Undocumented lti.grantSystemPriv(
priv_types   IN VARCHAR2,
grantee      IN VARCHAR2,
grant_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GRANTWORKSPACEPRIV
Undocumented lti.grantWorkspacePriv(
priv_types   IN VARCHAR2,
workspace    IN VARCHAR2,
grantee      IN VARCHAR2,
grant_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
HASWMADMIN
Undocumented lti.hasWMAdmin RETURN BOOLEAN;
BEGIN
  IF wmsys.lti.hasWMAdmin THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
*
PLS-00904: insufficient privilege to access object LTI
 
IMPORT
Undocumented lti.import(
staging_table                IN VARCHAR2,
to_table                     IN VARCHAR2,
to_workspace                 IN VARCHAR2,
from_workspace               IN VARCHAR2,
where_clause                 IN VARCHAR2,
import_scope                 IN VARCHAR2,
ancestor_savepoint_workspace IN VARCHAR2,
ancestor_savepoint_name      IN VARCHAR2,
apply_locks                  IN BOOLEAN,
enforceucflag                IN BOOLEAN,
enforcericflag               IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
MERGETABLE
Undocumented lti.mergeTable(
workspace        IN VARCHAR2,
table_id         IN VARCHAR2,
where_clause     IN VARCHAR2,
create_savepoint IN BOOLEAN,
remove_data      IN BOOLEAN,
auto_commit      IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
MERGEWORKSPACE
Undocumented lti.mergeWorkspace(
workspace        IN VARCHAR2,
create_savepoint IN BOOLEAN,
remove_workspace IN BOOLEAN,
auto_commit      IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
REFRESHTABLE
Undocumented lti.refreshTable(
workspace    IN VARCHAR2,
table_id     IN VARCHAR2,
where_clause IN VARCHAR2,
auto_commit  IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
REFRESHWORKSPACE
Refresh the workspace lti.refreshWorkspace(
workspace   IN VARCHAR2,
auto_commit IN BOOLEAN,
copy_data   IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
REMOVEASPARENTWORKSPACE
Remove the parent workspace lti.removeAsParentWorkspace(
mp_leaf_workspace IN VARCHAR2,
parent_workspace  IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REMOVEDEFERREDWORKSPACES
Undocumented lti.removeDeferredWorkspaces;
Protected by an ACCESSIBLE BY clause
 
REMOVEWORKSPACE
Undocumented lti.removeWorkspace(
workspace    IN VARCHAR2,
defer_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REMOVEWORKSPACETREE
Undocumented lti.removeWorkspaceTree(
workspace    IN VARCHAR2,
defer_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REVOKEGRAPHPRIV
Undocumented lti.revokeGraphPriv(
priv_types     IN VARCHAR2,
leaf_workspace IN VARCHAR2,
grantee        IN VARCHAR2,
node_types     IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REVOKESYSTEMPRIV
Undocumented lti.revokeSysemPriv(
priv_types IN VARCHAR2,
grantee    IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REVOKEWORKSPACEPRIV
Undocumented lti.revokeWorkspacePriv(
priv_types IN VARCHAR2,
workspace  IN VARCHAR2,
grantee    IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
ROLLBACKTABLE
Undocumented lti.rollbackTable(
workspace    IN VARCHAR2,
table_id     IN VARCHAR2,
sp_name      IN VARCHAR2,
where_clause IN VARCHAR2,
remove_locks IN BOOLEAN,
auto_commit  IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
ROLLBACKTOSP
Undocumented lti.rollbackToSP(
workspace      IN VARCHAR2,
savepoint_name IN VARCHAR2)
Protected by an ACCESSIBLE BY clause
 
ROLLBACKWORKSPACE
Undocumented lti.rollbackWorkspace(workspace IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
ROLLBACKWORKSPACE_INTERNAL
Undocumented lti.rolbackWorkspace_Internal(
in_state     IN VARCHAR2,
table_name   IN VARCHAR2,
cpver        IN NUMBER,
postver      IN NUMBER,
operation    IN VARCHAR2,
defer_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
SETACTIVETSFORDML
Undocumented lti.setActiveTSForDML;
exec wmsys.lti.setActiveTSForDML;
     *
PLS-00904: insufficient privilege to access object LTI
 
SETCONFLICTWORKSPACE_INTERNAL
Undocumented lti.setConflictWorkspace_Internal(state IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
SETWORKSPACELOCKMODEOFF
Disables Workspace Locking lti.setWorkspaceLockModeOff(workspace IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
SETWORKSPACELOCKMODEON
Enables Workspace Locking lti.setWorkspaceLockModeOn(
workspace IN VARCHAR2,
lockmode  IN VARCHAR2,
override  IN BOOLEAN);
Protected by an ACCESSIBLE BY clause

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WM
LT
LTAQ
LTDDL
LTDEFINER
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