Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

SYNC_UP_REP Procedure

This procedure 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. This procedure does not accept the storage table of a nested table.


Caution:

Do not execute this procedure unless directed to do so by Oracle Support Services.


Syntax

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

Parameters

Table 22-3 SYNC_UP_REP Procedure Parameters
Parameter Description
canon_sname

Schema containing the table or materialized view 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 materialized view to be synchronized.

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