Replication Management API Reference, 105 of 179

REPCAT_IMPORT_CHECK procedure

This procedure ensures that the objects in the replicated master group have the appropriate object identifiers and status values after you perform an export/import of a replicated object or an object used by Oracle replication.

Syntax

DBMS_REPCAT.REPCAT_IMPORT_CHECK (
   gname      IN   VARCHAR2,
   master     IN   BOOLEAN
   gowner     IN   VARCHAR2  := 'PUBLIC');

Parameters

Table 8-190 REPCAT_IMPORT_CHECK Procedure Parameters

Parameter	Description
gname	Name of the replicated master group. If you omit both parameters, then the procedure checks all replicated master groups at your current site.
master	Set this to `TRUE` if you are checking a master site and `FALSE` if you are checking a snapshot site.
gowner	Owner of the master group.

Exceptions

Table 8-191 REPCAT_IMPORT_CHECK Procedure Exceptions

Exception	Description
nonmaster	`MASTER` is `TRUE` and either the database is not a master site for the object group or the database is not the expected database.
nonsnapshot	`MASTER` is `FALSE` and the database is not a snapshot site for the object group.
missingobject	A valid replicated object in the object group does not exist.
missingrepgroup	The specified replicated object group does not exist.
missingschema	The specified replicated object group does not exist.