Oracle9i Replication Management API Reference
Release 1 (9.0.1)

Part Number A87502-01
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

Replication Catalog Views, 55 of 81


DBA_REPSITES_NEW

The DBA_REPSITES_NEW view lists the new replication sites that you plan to add to your replication environment.

See Also:

"Adding New Master Sites Without Quiescing the Master Group" for information about the procedure that adds new master sites to a replication environment 

Column  Datatype  NULL  Description 

EXTENSION_ID 

RAW(16) 

NOT NULL 

The identifier for a current pending request to add master databases to a master group without quiesce.  

GOWNER 

VARCHAR2(30) 

NOT NULL 

The name of the user who owns the master group. 

GNAME 

VARCHAR2(30) 

NOT NULL 

The name of the master group. 

DBLINK 

VARCHAR2(128) 

NOT NULL 

The database link for a new master site. 

FULL_INSTANTIATION 

VARCHAR2(1) 

 

Y indicates that the new database in DBLINK is to be added using full database export/import or change-based recovery.

N indicates that the new database in DBLINK is to be added using object-level export/import. 

MASTER_STATUS 

VARCHAR2(13) 

 

The instantiation status of a new master site. This value is only meaningful at the master definition site.

The possible values are:

READY: The new master site is ready.

INSTANTIATING: The new master site is in the process of being instantiated.

INSTANTIATED: The new master has been instantiated and is being prepared for replication activity. That is, the DBMS_REPCAT.PREPARE_INSTANTIATED_MASTER procedure has been run.

PREPARED: The propagation of deferred transactions is enabled from the new master site to other prepared masters, to existing masters, and to the master definition site. The new master is now prepared to participate in the replication environment. 


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