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, 56 of 69


REMOVE_MASTER_DATABASES Procedure

This procedure removes one or more master databases from a replication environment. This procedure regenerates the triggers and their associated packages at the remaining master sites. You must call this procedure from the master definition site.

Syntax

DBMS_REPCAT.REMOVE_MASTER_DATABASES (
   gname           IN   VARCHAR2,
   master_list     IN   VARCHAR2 |
   master_table    IN   DBMS_UTILITY.DBLINK_ARRAY);


Note:

This procedure is overloaded. The master_list and master_table parameters are mutually exclusive. 


Parameters

Table 48-114 REMOVE_MASTER_DATABASES Procedure Parameters
Parameter  Description 
gname
 

Name of the replication group associated with the replication environment. This prevents confusion if a master database is involved in more than one replication environment. 

master_list
 

A comma-separated list of fully qualified master database names that you want to remove from the replication environment. There must be no spaces between names in the list. 

master_table
 

In place of a list, you can specify the database names in a PL/SQL index-by table of type DBMS_UTILITY.DBLINK_ARRAY

Exceptions

Table 48-115 REMOVE_MASTER_DATABASES Procedure Exceptions
Exception  Description 
nonmasterdef
 

Invocation site is not the master definition site. 

nonmaster
 

At least one of the specified databases is not a master site. 

reconfigerror
 

One of the specified databases is the master definition site. 

commfailure
 

At least one remaining master site is not accessible. 


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