Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.REPCAT_IMPORT_CHECK

Purpose

To ensure that the objects in the replicated object group have the appropriate object identifiers and status values after you perform an export/import of a replicated object or an object used by the symmetric replication facility. For additional information, refer to

Syntax

The parameters for the REPCAT_IMPORT_CHECK procedure are described in Table 12 - 163, and the exceptions are listed in Table 12 - 164. The syntax for this procedure is shown below:

DBMS_REPCAT.REPCAT_IMPORT_CHECK(
		gname	IN	VARCHAR2,
				master	IN	BOOLEAN := TRUE)

Parameter Description
gname The name of the replicated object group. If you omit both parameters, the procedure checks all replicated object groups at your current site.
master Set this flag to TRUE if you are checking a master site or FALSE if you are checking a snapshot site.

Table 12 - 163. Parameters for REPCAT_IMPORT_CHECK

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

Table 12 - 164. Exceptions for REPCAT_IMPORT_CHECK

Parameter	Description
`gname`	The name of the replicated object group. If you omit both parameters, the procedure checks all replicated object groups at your current site.
`master`	Set this flag to TRUE if you are checking a master site or FALSE if you are checking a snapshot site.

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