Oracle LTI
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented Workspace Management internal utilities
AUTHID CURRENT_USER
Data Types ???
Dependencies
ALL_MP_PARENT_WORKSPACES LTUTIL SESSION_PRIVS
ALL_TAB_PRIVS_RECD LT_CTX_PKG SESSION_ROLES
ALL_WORKSPACE_SAVEPOINTS OWM_ASSERT_PKG USER_SYS_PRIVS
DBMS_STANDARD OWM_BULK_LOAD_PKG USER_VIEWS
DUAL OWM_IEXP_PKG USER_WM_PRIVS
LT OWM_MP_PKG USER_WORKSPACES
LTADM OWM_VSCRIPT_PKG WM$NV_PAIR_NT_TYPE
LTAQ PLITBLM WM$NV_PAIR_TYPE
LTPRIV ROLE_SYS_PRIVS WM_ERROR
LTRIC ROLE_TAB_PRIVS  
Documented No
First Available 20c
Security Model Owned by WMSYS with no privileges granted

This package, and all of its objects, are protected by an ACCESSIBLE BY clause.
Source {ORACLE_HOME}/rdbms/admin/owmltis.plb
Subprograms
 
ADDASPARENTWORKSPACE (new 20c)
Undocumented lti.addAsParentWorkspace(
workspace        IN VARCHAR2,
parent_workspace IN VARCHAR2)
Protected by an ACCESSIBLE BY clause
 
CHANGEWORKSPACETYPE (new 20c)
Undocumented lti.changeWorkspaceType(
workspace      IN VARCHAR2,
workspace_type IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
CHECKTABLEPRIVS (new 20c)
Undocumented lti.checkTablePrivs(
towner  IN VARCHAR2,
tabname IN VARCHAR2)
RETURN BOOLEAN;
Protected by an ACCESSIBLE BY clause
 
CHECKWHERECLAUSE (new 20c)
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 (new 20c)
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 (new 20c)
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 (new 20c)
Undocumented lti.createSavepoint(
workspace      IN VARCHAR2,
savepoint_name IN VARCHAR2,
description    IN VARCHAR2)
Protected by an ACCESSIBLE BY clause
 
CREATEWORKSPACE (new 20c)
Undocumented lti.createWorkspace(
workspace   IN VARCHAR2,
isrefreshed IN BOOLEAN,
description IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
DELETESAVEPOINT (new 20c)
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 (new 20c)
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 (new 20c)
Undocumented lti.gotoWorkspace_internal(state IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GRANTGRAPHPRIV (new 20c)
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 (new 20c)
Undocumented lti.grantSystemPriv(
priv_types   IN VARCHAR2,
grantee      IN VARCHAR2,
grant_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GRANTWORKSPACEPRIV (new 20c)
Undocumented lti.grantWorkspacePriv(
priv_types   IN VARCHAR2,
workspace    IN VARCHAR2,
grantee      IN VARCHAR2,
grant_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
HASWMADMIN (new 20c)
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 (new 20c)
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 (new 20c)
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 (new 20c)
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 (new 20c)
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 (new 20c)
Refresh the workspace lti.refreshWorkspace(
workspace   IN VARCHAR2,
auto_commit IN BOOLEAN,
copy_data   IN BOOLEAN);
Protected by an ACCESSIBLE BY clause
 
REMOVEASPARENTWORKSPACE (new 20c)
Remove the parent workspace lti.removeAsParentWorkspace(
mp_leaf_workspace IN VARCHAR2,
parent_workspace  IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REMOVEDEFERREDWORKSPACES (new 20c)
Undocumented lti.removeDeferredWorkspaces;
Protected by an ACCESSIBLE BY clause
 
REMOVEWORKSPACE (new 20c)
Undocumented lti.removeWorkspace(
workspace    IN VARCHAR2,
defer_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REMOVEWORKSPACETREE (new 20c)
Undocumented lti.removeWorkspaceTree(
workspace    IN VARCHAR2,
defer_option IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REVOKEGRAPHPRIV (new 20c)
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 (new 20c)
Undocumented lti.revokeSysemPriv(
priv_types IN VARCHAR2,
grantee    IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REVOKEWORKSPACEPRIV (new 20c)
Undocumented lti.revokeWorkspacePriv(
priv_types IN VARCHAR2,
workspace  IN VARCHAR2,
grantee    IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
ROLLBACKTABLE (new 20c)
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 (new 20c)
Undocumented lti.rollbackToSP(
workspace      IN VARCHAR2,
savepoint_name IN VARCHAR2)
Protected by an ACCESSIBLE BY clause
 
ROLLBACKWORKSPACE (new 20c)
Undocumented lti.rollbackWorkspace(workspace IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
ROLLBACKWORKSPACE_INTERNAL (new 20c)
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 (new 20c)
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 (new 20c)
Undocumented lti.setConflictWorkspace_Internal(state IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
SETWORKSPACELOCKMODEOFF (new 20c)
Disables Workspace Locking lti.setWorkspaceLockModeOff(workspace IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
SETWORKSPACELOCKMODEON (new 20c)
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
LTDTRG
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx