| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/prvthitr.plb |
| First Available |
2004 |
| Dependencies |
| DBA_INTERNAL_TRIGGERS |
DBMS_SNAP_INTERNAL |
DBMS_SYS_SQL |
| DBMS_INTERNAL_TRIGGER |
DBMS_SQL |
|
|
| Security Model |
Execute is granted to PUBLIC |
| |
| 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); |
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
exec dbms_itrigger_utl.sync_up_scdc('UWCLASS', 'MV_FORCE'); |
