Oracle | DBMS_ITRIGGER

Oracle DBMS_ITRIGGER_UTL 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 Undocumented but related to snapshot replication triggers

AUTHID CURRENT_USER

Dependencies

DBMS_INTERNAL_TRIGGER

DBMS_SNAP_INTERNAL

DBMS_SQL

Documented No

First Available 2004

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvthitr.plb

Subprograms

IMPORT_SCDC_TRIGGER_STRING

SYNC_UP_SCDC

IMPORT_SCDC_TRIGGER_STRING

Undocumented dbms_itrigger_utl.import_scdc_trigger_string(arg IN VARCHAR2) RETURN VARCHAR2;

TBD

SYNC_UP_SCDC

Synchronizes the existence of an internal trigger with a table or materialized view in the replication catalog. If the table or materialized view has replication support, then execute this procedure to create the internal replication trigger. If replication support does not exist, then this procedure destroys any related internal trigger. dbms_itrigger_utl.sync_up_scdc( canon_sname IN VARCHAR2, canon_oname IN VARCHAR2);

conn sys@pdbdev as sysdba

      

      CREATE MATERIALIZED VIEW uwclass.mv_force

      TABLESPACE uwdata

      NOCACHE

      LOGGING

      NOCOMPRESS

      NOPARALLEL

      BUILD IMMEDIATE

      REFRESH FORCE ON DEMAND

      WITH ROWID AS

      SELECT * FROM servers;

      

      conn uwclass/uwclass@pdbdev 

      

      exec dbms_itrigger_utl.sync_up_scdc('UWCLASS', 'MV_FORCE');