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