Oracle LTDTRG
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Workspace Management Triggers Utilities
AUTHID DEFINER
Dependencies
ALL_NESTED_TABLES LTRIC WM$COLUMN_PROPS
DBA_INDEXES LTUTIL WM$CONSTRAINTS_TABLE
DBA_IND_COLUMNS LT_CTX_PKG WM$DBA_TAB_COLS
DBA_IND_EXPRESSIONS OWM_ASSERT_PKG WM$NESTED_COLUMNS_TABLE
DBA_OBJECTS OWM_DDL_PKG WM$RIC_TABLE
DBMS_LOB OWM_DYNSQL_ACCESS WM$UDTRIG_INFO
LT PLITBLM WM_DDL_UTIL
LTADM UD_TRIGS  
Documented No
First Available Not Known
Security Model Owned by WMSYS with no privileges granted.

The package appears to be further protected with an ACCESSIBLE BY clause so likely can only be called by one of the objects identified as dependent above.
Source {ORACLE_HOME}/rdbms/admin/???
Subprograms
ADDNEWTODEFN CREATETRIGGERS TRIGGERSELECTCLAUSE
 
ADDNEWTODEFN
Undocumented ltdtrg.addNewToDefn(
s      IN VARCHAR2,
colstr IN VARCHAR2,
prefix IN VARCHAR2);
TBD
 
CREATETRIGGERS
Undocumented ltdtrg.createTriggers(
owner_name_var     IN VARCHAR2,
table_name_var     IN VARCHAR2,
colstr_var         IN VARCHAR2,
keycols_var        IN VARCHAR2,
notifyconflicts    IN BOOLEAN,
ric_sql_ins        IN CLOB,
ric_sql_upd        IN CLOB,
ric_sql_del        IN CLOB,
vtid               IN NUMBER,
DISPATCHERNAME_VAR IN VARCHAR2,
actualstr          IN VARCHAR2,
actualstr_io       IN VARCHAR2,
setclause          IN VARCHAR2,
insertstr_io       IN VARCHAR2,
vardecls           IN VARCHAR2,
keycols_nv_var     IN VARCHAR2,
bir                IN BOOLEAN,
air                IN BOOLEAN,
bur                IN BOOLEAN,
aur                IN BOOLEAN,
bdr                IN BOOLEAN,
adr                IN BOOLEAN,
hist               IN VARCHAR2,
vt_option          IN NUMBER,
buffer_code        IN BOOLEAN);
TBD
 
TRIGGERSELECTCLAUSE
Undocumented ltdtrg.triggerSelectClause(
owner_name_var IN VARCHAR2,
table_name     IN VARCHAR2,
verlist        IN BOOLEAN)
RETURN VARCHAR2;
SQL> SELECT wmsys.ltdtrg.triggerSelectClause('C##SH', 'SALES')
  2  FROM dual;
SELECT wmsys.ltdtrg.triggerSelectClause('C##SH', 'SALES')
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object LTDTRG


SQL> sho user
USER is "WMSYS"

Related Topics
Built-in Functions
Built-in Packages
DBMS_WM
LT
LTAQ
OWM_ASSERT
OWM_CPKG_PKG
OWM_DDL
OWM_IEXP_PKG
What's New In 12cR2
What's New In 18cR3

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