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]

TABLE: SYSTEM.REPCAT$_EXTENSION

Object Details

Object Name:	REPCAT$_EXTENSION
Object Type:	TABLE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Information about replication extension requests

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00139042

EXTENSION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00139042	NORMAL	UNIQUE	SYSTEM	EXTENSION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_SITES_NEW		REPCAT$_EXTENSION	REPCAT$_SITES_NEW EXTENSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXTENSION_ID	RAW	(16)	Yes	Globally unique identifier for replication extension
EXTENSION_CODE	NUMBER			Kind of replication extension
MASTERDEF	VARCHAR2	(128)		Master definition site for replication extension
EXPORT_REQUIRED	VARCHAR2	(1)		YES if this extension requires an export, and NO if no export is required
REPCATLOG_ID	NUMBER			Identifier of repcatlog records related to replication extension
EXTENSION_STATUS	NUMBER			Status of replication extension
FLASHBACK_SCN	NUMBER			Flashback_scn for export or change-based recovery for replication extension
PUSH_TO_MDEF	VARCHAR2	(1)		YES if existing masters partially push to masterdef, NO if no pushing
PUSH_TO_NEW	VARCHAR2	(1)		YES if existing masters partially push to new masters, NO 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
,      EXTENSION_CODE
,      MASTERDEF
,      EXPORT_REQUIRED
,      REPCATLOG_ID
,      EXTENSION_STATUS
,      FLASHBACK_SCN
,      PUSH_TO_MDEF
,      PUSH_TO_NEW
,      PERCENTAGE_FOR_CATCHUP_MDEF
,      CYCLE_SECONDS_MDEF
,      PERCENTAGE_FOR_CATCHUP_NEW
,      CYCLE_SECONDS_NEW
FROM SYSTEM.REPCAT$_EXTENSION;

Dependencies

[top of page]

SYSTEM.REPCAT$_EXTENSION does not reference any database object

SYSTEM.REPCAT$_EXTENSION is referenced by following:

SYS: DBA_REPEXTENSIONS; DBMS_ASYNCRPC_PUSH - show dependent code; DBMS_DEFER_REPCAT - show dependent code; DBMS_REPCAT_ADD_MASTER - show dependent code; DBMS_REPCAT_COMMON_UTL - show dependent code; DBMS_REPCAT_DEFINER - show dependent code