Replication Management API Reference, 167 of 179

SYNC_UP_REP procedure

This procedure synchronizes the existence of an internal trigger with a table or snapshot in the replication catalog. If the table or snapshot has replication support, execute this procedure to create the internal replication trigger. If replication support does not exist, destroy any related internal trigger.

Caution:
This procedure should only be executed under the guidance of Oracle Worldwide Support.

Syntax

DBMS_REPUTIL.SYNC_UP_REP (
   canon_sname    IN   VARCHAR2,
   canon_oname    IN   VARCHAR2);

Parameters

Table 8-304 SYNC_UP_REP Procedure Parameters

Parameter	Description
canon_sname	Schema containing the table or snapshot to be synchronized. This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).
canon_oname	Name of the table or snapshot to be synchronized. This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).

Parameter

Description

canon_sname

Schema containing the table or snapshot to be synchronized.

This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).

canon_oname

Name of the table or snapshot to be synchronized.

This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).