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

Object Details

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

Information about replicated objects

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_REPOBJECT_PRIMARY

SNAME
ONAME
TYPE

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_REPOBJECT_PRIMARY	NORMAL	UNIQUE	SYSTEM	SNAME ONAME TYPE
REPCAT$_REPOBJECT_GNAME	NORMAL	NONUNIQUE	SYSTEM	GNAME ONAME TYPE GOWNER
REPCAT$_REPOBJECT_PRNT_IDX	NORMAL	NONUNIQUE	SYSTEM	GNAME GOWNER

Foreign Keys

Table	Foreign Table	Foreign Key Column
REPCAT$_REPOBJECT	REPCAT$_REPCAT	REPCAT$_REPOBJECT GNAME REPCAT$_REPOBJECT GOWNER
REPCAT$_GENERATED	REPCAT$_REPOBJECT	REPCAT$_GENERATED SNAME REPCAT$_GENERATED ONAME REPCAT$_GENERATED TYPE
REPCAT$_GENERATED	REPCAT$_REPOBJECT	REPCAT$_GENERATED BASE_SNAME REPCAT$_GENERATED BASE_ONAME REPCAT$_GENERATED BASE_TYPE
REPCAT$_KEY_COLUMNS	REPCAT$_REPOBJECT	REPCAT$_KEY_COLUMNS SNAME REPCAT$_KEY_COLUMNS ONAME REPCAT$_KEY_COLUMNS TYPE
REPCAT$_REPCOLUMN	REPCAT$_REPOBJECT	REPCAT$_REPCOLUMN SNAME REPCAT$_REPCOLUMN ONAME REPCAT$_REPCOLUMN TYPE
REPCAT$_REPPROP	REPCAT$_REPOBJECT	REPCAT$_REPPROP SNAME REPCAT$_REPPROP ONAME REPCAT$_REPPROP TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SNAME	VARCHAR2	(128)	Yes	Name of the object owner
ONAME	VARCHAR2	(128)	Yes	Name of the object
TYPE	NUMBER		Yes	Type of the object
ID	NUMBER			Identifier of the local object
OBJECT_COMMENT	VARCHAR2	(80)		Description of the replicated object
STATUS	NUMBER			Status of the last create or alter request on the local object
GENPACKAGE	NUMBER			Status of whether the object needs to generate replication package
GENPLOGID	NUMBER			Log id of message sent for generating package support
GENTRIGGER	NUMBER			Status of whether the object needs to generate replication trigger
GENTLOGID	NUMBER			Log id of message sent for generating trigger support
GOWNER	VARCHAR2	(128)		Owner of the object's object group
GNAME	VARCHAR2	(30)		Name of the object's object group
FLAG	RAW	(4)		Information about replicated object
HASHCODE	RAW	(17)		Hashcode of objects of TYPE
VERSION#	NUMBER			Version of objects of TYPE

Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      ID
,      OBJECT_COMMENT
,      STATUS
,      GENPACKAGE
,      GENPLOGID
,      GENTRIGGER
,      GENTLOGID
,      GOWNER
,      GNAME
,      FLAG
,      HASHCODE
,      VERSION#
FROM SYSTEM.REPCAT$_REPOBJECT;

Dependencies

[top of page]

SYSTEM.REPCAT$_REPOBJECT does not reference any database object

SYSTEM.REPCAT$_REPOBJECT is referenced by following:

SYS: DBMS_DEFER_DEFINER - show dependent code; DBMS_DEFER_REPCAT - show dependent code; DBMS_INTERNAL_REPCAT - show dependent code; DBMS_OFFLINE_OG_INTERNAL - show dependent code; DBMS_OFFLINE_RGT_INTERNAL - show dependent code; DBMS_OFFLINE_SNAPSHOT_INTERNAL - show dependent code; DBMS_REPCAT_ADD_MASTER - show dependent code; DBMS_REPCAT_ADMIN - show dependent code; DBMS_REPCAT_CONF - show dependent code; DBMS_REPCAT_FLA - show dependent code; DBMS_REPCAT_INTERNAL - show dependent code; DBMS_REPCAT_MAS - show dependent code; DBMS_REPCAT_MIG_INTERNAL - show dependent code; DBMS_REPCAT_OBJ_UTL - show dependent code; DBMS_REPCAT_RGT_CUST - show dependent code; DBMS_REPCAT_SNA_UTL - show dependent code; DBMS_REPCAT_UTL - show dependent code; DBMS_REPCAT_UTL3 - show dependent code; DBMS_REPCAT_UTL4 - show dependent code; REPCAT_REPFLAVOR_COLUMNS; REPCAT_REPOBJECT_BASE; _ALL_REPFLAVOR_OBJECTS