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$_SITES_NEW

Object Details

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

Information about new masters for replication extension

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_SITES_NEW_PK

EXTENSION_ID
GOWNER
GNAME
DBLINK

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_SITES_NEW_PK	NORMAL	UNIQUE	SYSTEM	EXTENSION_ID GOWNER GNAME DBLINK
REPCAT$_SITES_NEW_FK1_IDX	NORMAL	NONUNIQUE	SYSTEM	EXTENSION_ID
REPCAT$_SITES_NEW_FK2_IDX	NORMAL	NONUNIQUE	SYSTEM	GNAME GOWNER

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_SITES_NEW		REPCAT$_EXTENSION	REPCAT$_SITES_NEW EXTENSION_ID
REPCAT$_SITES_NEW		REPCAT$_REPCAT	REPCAT$_SITES_NEW GNAME REPCAT$_SITES_NEW GOWNER

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	NUMBER			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 SYSTEM.REPCAT$_SITES_NEW;

Dependencies

[top of page]

SYSTEM.REPCAT$_SITES_NEW does not reference any database object

SYSTEM.REPCAT$_SITES_NEW is referenced by following:

SYS: DBA_REPSITES_NEW; 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; DBMS_REPCAT_SNA_UTL - show dependent code