Oracle LTRIC
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 Workspace Management Support Utilities
AUTHID DEFINER
Dependencies
ALL_CONSTRAINTS LTUTIL WM$MODIFIED_TABLES
DBA_CONSTRAINTS LT_CTX_PKG WM$RIC_LOCKING_TABLE
DBA_CONS_COLUMNS OWM_ASSERT_PKG WM$RIC_TABLE
DBA_OBJECTS OWM_BULK_LOAD_PKG WM$RIC_TRIGGERS_TABLE
DBA_TABLES OWM_DDL_PKG WM$UDTRIG_DISPATCHER_SEQUENCE
DBA_TAB_COLS OWM_DYNSQL_ACCESS WM$UDTRIG_DISPATCH_PROCS
DBA_TRIGGERS OWM_IEXP_PKG WM$UDTRIG_INFO
DBMS_LOB OWM_MIG_PKG WM$UP_DEL_TRIG_NAME_SEQUENCE
DBMS_LOCK OWM_MP_PKG WM$VERSIONED_TABLES
DBMS_ROWID OWM_VSCRIPT_PKG WM$VERSION_HIERARCHY_TABLE
DUAL PLITBLM WM$VERSION_TABLE
LT UD_TRIGS WM$WORKSPACES_TABLE
LTADM WM$CURRENT_CONS_VERSIONS_VIEW WM_DDL_UTIL
LTDDL WM$DBA_TAB_COLS WM_ERROR
LTDTRG    
Documented No
First Available Not known
Security Model Owned by WMSYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/owmrics.plb
{ORACLE_HOME}/rdbms/admin/owmricb.plb
Subprograms
 
APPLY_RIC_COMMIT_TABLE
Undocumented
Overload 1
ltric.apply_ric_commit_table(
state_name IN VARCHAR2,
ct_owner   IN VARCHAR2,
ct_name    IN VARCHAR2);
TBD
Overload 2 ltric.apply_ric_commit_table(
state_name      IN     VARCHAR2,
recurctabowners IN OUT wmsys.ltutil.wm$ident_tab,
recurctabnames  IN OUT wmsys.ltutil.wm$ident_tab);
TBD
 
APPLY_RIC_CONSTRAINTS
Undocumented ltric.apply_ric_constraints(
table_owner             IN VARCHAR2,
table_name              IN VARCHAR2,
cons_view_where_clause  IN VARCHAR2,
dirty_rows_where_clause IN VARCHAR2,
dirty_version           IN NUMBER);
TBD
 
APPLY_RIC_RESTRICT
Undocumented ltric.apply_ric_restrict(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
ver             IN NUMBER,
otherws         IN VARCHAR2,
otherwsver      IN NUMBER,
mp_root_ws      IN VARCHAR2,
opvar           IN VARCHAR2);
TBD
 
APPLY_RIC_RESTRICT_POST
Undocumented ltric.apply_ric_restrict_post(
child_workspace      IN VARCHAR2,
parent_workspace_var IN VARCHAR2,
post_ver             IN NUMBER,
parver               IN NUMBER,
mp_root_workspace    IN VARCHAR2);
TBD
 
APPLY_SELF_REF_RIC
Undocumented ltric.apply_self_ref_ric(
schemaname IN VARCHAR2,
table_name IN VARCHAR2,
ver        IN NUMBER,
targetver  IN NUMBER,
userwc     IN VARCHAR2);
TBD
 
BACKUPRICLOCKSLIST
Undocumented ltric.backupRicLocksList(
exec wmsys.ltric.backupRicLocksList;
BEGIN wmsys.ltric.backupRicLocksList; END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object LTRIC
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
CHECKRICONRFRSHBYFLIPPING
Undocumented ltric.checkRicOnRfrshByFlipping(
parent_ws             IN VARCHAR2,
child_ws              IN VARCHAR2,
parent_ws_earlier_ver IN NUMBER);
TBD
 
CREATERICLOCKINGTABLES
Undocumented ltric.createRicLockingTables(
pt_owner_v   IN VARCHAR2,
pt_name_v    IN VARCHAR2,
ct_owner_var IN VARCHAR2,
ct_name_var  IN VARCHAR2,
logundo      IN BOOLEAN);
TBD
 
CREATERICWHERECLAUSE
Undocumented ltric.createRicWhereClause(
ct_col_qualifier IN VARCHAR2,
ct_cols          IN VARCHAR2,
pt_col_qualifier IN VARCHAR2,
pt_cols          IN VARCHAR2,
newstr           IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
DO_CR_RIC_CHECK
Undocumented ltric.do_cr_ric_check(
parent_ws         IN VARCHAR2,
parent_ws_curver  IN NUMBER,
child_ws          IN VARCHAR2,
parver            IN NUMBER,
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
opvar             IN VARCHAR2,
resolveop         IN VARCHAR2,
mp_root_workspace IN VARCHAR2);
TBD
 
DROPRICLOCKINGTABLES
Undocumented ltric.dropRicLockingTables(
pt_owner_var IN VARCHAR2,
pt_name_var  IN VARCHAR2);
TBD
 
FINDRICSET
Undocumented ltric.findRicSet(
table_owner        IN VARCHAR2,
table_name         IN VARCHAR2,
result_table_owner IN VARCHAR2,
result_table       IN VARCHAR2);
TBD
 
GENRICVIEWS
Undocumented ltric.genricViews(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
evoperation IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
GENVTPTNOTEXISTSWC
Undocumented ltric.genVtptNotExistsWc(
ct_cols_var  IN VARCHAR2,
pt_cols_var  IN VARCHAR2,
pt_owner_var IN VARCHAR2,
pt_name_var  IN VARCHAR2,
ctqual       IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETMODVER
Undocumented ltric.getModVer(workspace_var IN VARCHAR2) RETURN NUMBER;
TBD
 
GETPTBEFORETRIGSTRS
Undocumented ltric.getPtBeforeTrigStrs(
ct_owner_name  IN  VARCHAR2,
table_name     IN  VARCHAR2,
par_tab_owner  IN  VARCHAR2,
par_tab_name   IN  VARCHAR2,
upd_trig_name  IN  VARCHAR2,
ric_update_sql OUT CLOB,
del_trig_name  IN  VARCHAR2,
ric_delete_sql OUT CLOB);
TBD
 
GETPTVTNONSEQUENCEDCODE
Undocumented ltric.getPtvtNonSequencedCode(
table_owner IN VARCHAR2,
table_name  IN VARCHAR2)
RETURN CLOB;
TBD
 
GETRICINSTEADOFTRIGSTRS
Undocumented ltric.getricInsteadOfTrigStrs(
owner_name_var  IN     VARCHAR2,
table_name      IN     VARCHAR2,
ric_insert_sql  IN OUT CLOB,
ric_update_sql  IN OUT CLOB,
ric_delete_sql  IN OUT CLOB,
recreatecttrigs IN     NUMBER);
TBD
 
GETRICLOCKNOS
Undocumented ltric.getRicLockNos(
pt_owner_var IN  VARCHAR2,
pt_name_var  IN  VARCHAR2,
slocknovar   OUT NUMBER,
elocknovar   OUT NUMBER);
TBD
 
GETRICLOCKS
Undocumented ltric.getRicLocks(
pt_owner  IN VARCHAR2,
pt_name   IN VARCHAR2,
slockno_v IN NUMBER,
elockno_v IN NUMBER,
optype    IN NUMBER);
TBD
 
GETRICLOCKSFORTABLE
Undocumented ltric.getRicLocksForTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2;
TBD
 
GETRICSESSLOCKSFORTABLE
Undocumented ltric.getRicSessLocksForTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
GETRICSFROMSKELETONTABLES
Undocumented ltric.getRicsFromSkeletonTables(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
enforce_ric   IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
GETSTATUS
Undocumented ltric.getStatus(
status       IN VARCHAR2,
forcedisable IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GETVARIABLE_C
Undocumented ltric.getVariable_c(varname IN VARCHAR2) RETURN wmsys.ltutil.cons_violation_tab;
TBD
 
INITIALIZERICLOCKINGVARS
Undocumented ltric.initializericlockingvars;
exec wmsys.tric.initializericlockingvars;
 
ISPARENTTABLE
Undocumented ltric.isParentTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
LOCKRICROWS
Undocumented ltric.lockRicRows(
table_owner  IN VARCHAR2,
table_name   IN VARCHAR2,
state_var    IN VARCHAR2,
opcode       IN VARCHAR2,
where_clause IN VARCHAR2,
check_conf   IN BOOLEAN);
TBD
 
NEEDTODECLVTVARS
Undocumented ltric.needToDeclVTVars(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
PROCESSCONSTRAINTVIOLATIONS
Undocumented ltric.processConstraintViolations(constraint_cur IN REF CURSOR) RETURN NUMBER;
TBD
 
RECREATEPTUPDDELTRIGGERS
Undocumented ltric.recreatePtUpdDelTriggers;
exec wmsys.ltric.recreatePtUpdDelTriggers;
BEGIN wmsys.ltric.recreateptupddeltriggers; END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object LTRIC
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
RELRICSESSLOCKSFORTABLE
Undocumented ltric.relRicSessLocksForTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
RESTORERICLOCKSLIST
Undocumented ltric.restoreRicLocksList;
exec wmsys.ltric.restoreRicLocksList;
BEGIN wmsys.ltric.restoreRiclockslist; END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object LTRIC
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
RIC_DISABLE_VERSNING_INTERNAL
Undocumented ltric.ric_disable_versning_internal(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
keepwmvalid   IN BOOLEAN);
TBD
 
RIC_ENABLE_VERSIONING_INTERNAL
Undocumented ltric.ric_enable_versioning_internal(
table_owner_v  IN     VARCHAR2,
table_name_v   IN     VARCHAR2,
ric_insert_sql IN OUT CLOB,
ric_update_sql IN OUT CLOB,
ric_delete_sql IN OUT CLOB);
TBD
 
SETVARIABLE
Undocumented ltric.setVariable(
varname IN VARCHAR2,
value_n IN NUMBER,
value_b IN BOOLEAN,
value_i IN wmsys.ltutil.wm$full_ident_tab);
TBD
 
UPDATERICWEIGHTS
Undocumented ltric.updateRicWeights(
pt_owner_var    IN VARCHAR2,
pt_name_var     IN VARCHAR2,
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
LTAQ
LTDTRG
LTI
LTPRIV
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