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

Object Details

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

Flavors defined for replicated object groups

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Unique Key: REPCAT$_FLAVORS_UNQ1

GNAME
FLAVOR_ID
GOWNER

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_FLAVORS_GNAME	NORMAL	UNIQUE	SYSTEM	GNAME FNAME GOWNER
REPCAT$_FLAVORS_UNQ1	NORMAL	UNIQUE	SYSTEM	GNAME FLAVOR_ID GOWNER
REPCAT$_FLAVORS_FK1_IDX	NORMAL	NONUNIQUE	SYSTEM	GNAME GOWNER
REPCAT$_FLAVORS_FNAME	NORMAL	NONUNIQUE	SYSTEM	FNAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_FLAVORS		REPCAT$_REPCAT	REPCAT$_FLAVORS GNAME REPCAT$_FLAVORS GOWNER
REPCAT$_FLAVOR_OBJECTS		REPCAT$_FLAVORS	REPCAT$_FLAVOR_OBJECTS GNAME REPCAT$_FLAVOR_OBJECTS FLAVOR_ID REPCAT$_FLAVOR_OBJECTS GOWNER

Columns

Name	Datatype	Length	Mandatory	Comments
FLAVOR_ID	NUMBER		Yes	Flavor identifier, unique within object group
GOWNER	VARCHAR2	(128)		Owner of the object group
GNAME	VARCHAR2	(30)	Yes	Name of the object group
FNAME	VARCHAR2	(30)		Name of the flavor
CREATION_DATE	DATE			Date on which the flavor was created
CREATED_BY	NUMBER			Identifier of user that created the flavor
PUBLISHED	VARCHAR2	(1)		Indicates whether flavor is published (Y/N) or obsolete (O)

Query Text

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


SELECT FLAVOR_ID
,      GOWNER
,      GNAME
,      FNAME
,      CREATION_DATE
,      CREATED_BY
,      PUBLISHED
FROM SYSTEM.REPCAT$_FLAVORS;

Dependencies

[top of page]

SYSTEM.REPCAT$_FLAVORS does not reference any database object

SYSTEM.REPCAT$_FLAVORS is referenced by following:

SYS: ALL_REPFLAVORS; DBA_REGISTERED_MVIEW_GROUPS; DBA_REGISTERED_SNAPSHOT_GROUPS; DBA_REPFLAVORS; DBA_REPFLAVOR_OBJECTS; DBMS_OFFLINE_RGT_INTERNAL - show dependent code; DBMS_REPCAT_ADD_MASTER - show dependent code; DBMS_REPCAT_FLA - show dependent code; DBMS_REPCAT_FLA_MAS - show dependent code; DBMS_REPCAT_FLA_UTL - show dependent code; DBMS_REPCAT_MAS - show dependent code; DBMS_REPCAT_OBJ_UTL - show dependent code; DBMS_REPCAT_RGT_CUST - show dependent code; DBMS_REPCAT_RQ - show dependent code; DBMS_REPCAT_UTL - show dependent code; DBMS_REPCAT_UTL3 - show dependent code; REPCAT_REPCAT; REPCAT_REPFLAVOR_COLUMNS; USER_REPFLAVORS; _ALL_REPFLAVOR_OBJECTS