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_OFFLINE_OG, 2 of 6


BEGIN_INSTANTIATION Procedure

This procedure starts offline instantiation of a master group. You must call this procedure from the master definition site.


Note:

This procedure is used to perform an offline instantiation of a master table in a multimaster replication environment.

This procedure should not be confused with the procedures in the DBMS_OFFLINE_SNAPSHOT package (used for performing an offline instantiation of a materialized view) or with the procedures in the DBMS_REPCAT_INSTANTIATE package (used for instantiating a deployment template). See these respective packages for more information on their usage. 


Syntax

DBMS_OFFLINE_OG.BEGIN_INSTANTIATION (
   gname     IN   VARCHAR2,
   new_site  IN   VARCHAR2
   fname     IN   VARCHAR2);

Parameters

Table 32-2 BEGIN_INSTANTIATION Procedure Parameters
Parameter  Description 
gname
 

Name of the replication group that you want to replicate to the new site. 

new_site
 

The fully qualified database name of the new site to which you want to replicate the replication group. 

fname
 

This parameter is for internal use only.

Note: Do not set this parameter unless directed to do so by Oracle Support Services. 

Exceptions

Table 32-3 BEGIN_INSTANTIATION Procedure Exceptions
Exception  Description 
badargument
 

NULL or empty string for replication group or new master site name. 

dbms_repcat.nonmasterdef
 

This procedure must be called from the master definition site. 

sitealreadyexists
 

Specified site is already a master site for this replication group. 

wrongstate
 

Status of master definition site must be quiesced. 

dbms_repcat.missingrepgroup
 

gname does not exist as a master group. 

dbms_repcat.missing_flavor
 

If you receive this exception, contact Oracle Support Services. 


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