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

Object Details

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

Objects generated to support replication

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_REPGEN_PRIMARY

SNAME
ONAME
TYPE
BASE_SNAME
BASE_ONAME
BASE_TYPE

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_REPGEN_PRIMARY	NORMAL	UNIQUE	SYSTEM	SNAME ONAME TYPE BASE_SNAME BASE_ONAME BASE_TYPE
REPCAT$_GENERATED_N1	NORMAL	NONUNIQUE	SYSTEM	BASE_SNAME BASE_ONAME BASE_TYPE
REPCAT$_REPGEN_PRNT_IDX	NORMAL	NONUNIQUE	SYSTEM	SNAME ONAME TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_GENERATED		REPCAT$_REPOBJECT	REPCAT$_GENERATED BASE_SNAME REPCAT$_GENERATED BASE_ONAME REPCAT$_GENERATED BASE_TYPE
REPCAT$_GENERATED		REPCAT$_REPOBJECT	REPCAT$_GENERATED SNAME REPCAT$_GENERATED ONAME REPCAT$_GENERATED TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SNAME	VARCHAR2	(128)	Yes	Schema containing the generated object
ONAME	VARCHAR2	(128)	Yes	Name of the generated object
TYPE	NUMBER		Yes	Type of the generated object
REASON	NUMBER			Reason the object was generated
BASE_SNAME	VARCHAR2	(128)	Yes	Name of the object's owner
BASE_ONAME	VARCHAR2	(128)	Yes	Name of the object
BASE_TYPE	NUMBER		Yes	Type of the object
PACKAGE_PREFIX	VARCHAR2	(128)		Prefix for package wrapper
PROCEDURE_PREFIX	VARCHAR2	(128)		Procedure prefix for package wrapper or procedure wrapper
DISTRIBUTED	VARCHAR2	(1)		Is the generated object separately generated at each master

Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      REASON
,      BASE_SNAME
,      BASE_ONAME
,      BASE_TYPE
,      PACKAGE_PREFIX
,      PROCEDURE_PREFIX
,      DISTRIBUTED
FROM SYSTEM.REPCAT$_GENERATED;

Dependencies

[top of page]

SYSTEM.REPCAT$_GENERATED does not reference any database object

SYSTEM.REPCAT$_GENERATED is referenced by following:

SYS: DBMS_DEFER_REPCAT - show dependent code; DBMS_REPCAT_CONF - show dependent code; DBMS_REPCAT_FLA - show dependent code; DBMS_REPCAT_MAS - show dependent code; DBMS_REPCAT_MIG_INTERNAL - show dependent code; DBMS_REPCAT_SNA_UTL - show dependent code; DBMS_REPCAT_UTL - show dependent code; DBMS_REPCAT_UTL3 - show dependent code; REPCAT_GENERATED; REPCAT_REPPROP