eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS._ALL_REPSITES_NEW

Object Details

Object Name:	_ALL_REPSITES_NEW
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information about new masters for replication extension

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	RAW	(16)	Yes	Globally unique identifier for replication extension
GOWNER	VARCHAR2	(128)	Yes	Owner of the object group
GNAME	VARCHAR2	(30)	Yes	Name of the replicated object group
DBLINK	VARCHAR2	(128)	Yes	A database site that will replicate the object group
FULL_INSTANTIATION	VARCHAR2	(1)		Y if the database uses full-database export or change-based recovery
MASTER_STATUS	VARCHAR2	(13)		Instantiation status of the new master

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXTENSION_ID
,      GOWNER
,      GNAME
,      DBLINK
,      FULL_INSTANTIATION
,      MASTER_STATUS
FROM SYS._ALL_REPSITES_NEW;

Dependencies

[top of page]

SYS._ALL_REPSITES_NEW references the following:

SYS: DBA_REPSITES_NEW

SYS._ALL_REPSITES_NEW is referenced by following:

PUBLIC: _ALL_REPSITES_NEW