Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_REPCAT, 58 of 69


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 Oracle Replication.

Syntax

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

Parameters

Table 48-118 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 48-119 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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback