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_REPEXTENSIONS

Object Details

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

Information about replication extension requests

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	RAW	(16)	Yes	Globally unique identifier for replication extension
REQUEST	VARCHAR2	(15)		Kind of replication extension
MASTERDEF	VARCHAR2	(128)		Master definition site for replication extension
EXPORT_REQUIRED	VARCHAR2	(3)		Y if this extension requires an export, and N if no export is required
REPCATLOG_ID	NUMBER			Identifier of repcatlog records related to replication extension
EXTENSION_STATUS	VARCHAR2	(13)		Status of replication extension
FLASHBACK_SCN	NUMBER			FLASHBACK_SCN for export or change-based recovery for replication extension
BREAK_TRANS_TO_MASTERDEF	VARCHAR2	(3)		Y if existing masters partially push to masterdef, N if no pushing
BREAK_TRANS_TO_NEW_MASTERS	VARCHAR2	(3)		Y if existing masters partially push to new masters, N if no pushing
PERCENTAGE_FOR_CATCHUP_MDEF	NUMBER			Fraction of push to masterdef cycle devoted to catching up
CYCLE_SECONDS_MDEF	NUMBER			Length of push to masterdef cycle when catching up
PERCENTAGE_FOR_CATCHUP_NEW	NUMBER			Fraction of push to new masters cycle devoted to catching up
CYCLE_SECONDS_NEW	NUMBER			Length of push to new masters cycle when catching up

Query Text

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


SELECT EXTENSION_ID
,      REQUEST
,      MASTERDEF
,      EXPORT_REQUIRED
,      REPCATLOG_ID
,      EXTENSION_STATUS
,      FLASHBACK_SCN
,      BREAK_TRANS_TO_MASTERDEF
,      BREAK_TRANS_TO_NEW_MASTERS
,      PERCENTAGE_FOR_CATCHUP_MDEF
,      CYCLE_SECONDS_MDEF
,      PERCENTAGE_FOR_CATCHUP_NEW
,      CYCLE_SECONDS_NEW
FROM SYS._ALL_REPEXTENSIONS;

Dependencies

[top of page]

SYS._ALL_REPEXTENSIONS references the following:

SYS: DBA_REPEXTENSIONS

SYS._ALL_REPEXTENSIONS is referenced by following:

PUBLIC: _ALL_REPEXTENSIONS