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

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.