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

REPCAT_IMPORT_CHECK Procedure

This procedure ensures that the objects in the 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 Advanced Replication.


Note:

You can use either Data Pump export/import or original export/import to perform exports and imports in an Advanced Replication environment. General references to export/import in this document refer to both Data Pump and original export/import.


Syntax

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

Parameters

Table 18-120 REPCAT_IMPORT_CHECK Procedure Parameters  
Parameter Description
gname

Name of the master group. If you omit both parameters, then the procedure checks all 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 materialized view site.

gowner

Owner of the master group.

Exceptions

Table 18-121 REPCAT_IMPORT_CHECK Procedure Exceptions  
Exception Description
nonmaster

master is true and either the database is not a master site for the replication group or the database is not the expected database.

nonmview

master is false and the database is not a materialized view site for the replication group.

missingobject

A valid replicated object in the replication group does not exist.

missingrepgroup

The specified replicated replication group does not exist.

missingschema

The specified replicated replication group does not exist.