Oracle LTI
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 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 means of 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;
/
 IF wmsys.lti.hasWMAdmin THEN
*
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00904: insufficient privilege to access object LTI
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
 
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;
BEGIN wmsys.lti.setActiveTSForDML; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object LTI
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
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 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx