Oracle | LTRIC

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	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