Oracle | LTRIC

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	GENVTPTNOTEXISTSWC	INITIALIZERICLOCKINGVARS
APPLY_RIC_CONSTRAINTS	GETMODVER	ISPARENTTABLE
APPLY_RIC_RESTRICT	GETPTBEFORETRIGSTRS	LOCKRICROWS
APPLY_RIC_RESTRICT_POST	GETPTVTNONSEQUENCEDCODE	NEEDTODECLVTVARS
APPLY_SELF_REF_RIC	GETRICINSTEADOFTRIGSTRS	PROCESSCONSTRAINTVIOLATIONS
BACKUPRICLOCKSLIST	GETRICLOCKNOS	RECREATEPTUPDDELTRIGGERS
CHECKRICONRFRSHBYFLIPPING	GETRICLOCKS	RELRICSESSLOCKSFORTABLE
CREATERICLOCKINGTABLES	GETRICLOCKSFORTABLE	RESTORERICLOCKSLIST
CREATERICWHERECLAUSE	GETRICSESSLOCKSFORTABLE	RIC_DISABLE_VERSNING_INTERNAL
DO_CR_RIC_CHECK	GETRICSFROMSKELETONTABLES	RIC_ENABLE_VERSIONING_INTERNAL
DROPRICLOCKINGTABLES	GETSTATUS	SETVARIABLE
FINDRICSET	GETVARIABLE_C	UPDATERICWEIGHTS
GENRICVIEWS

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