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

Object Details

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

Replicated objects in flavors

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_FLAVOR_OBJECTS_PK

SNAME
ONAME
TYPE
GNAME
FLAVOR_ID
GOWNER

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_FLAVOR_OBJECTS_PK	NORMAL	UNIQUE	SYSTEM	SNAME ONAME TYPE GNAME FLAVOR_ID GOWNER
REPCAT$_FLAVOR_OBJECTS_FG	NORMAL	NONUNIQUE	SYSTEM	FLAVOR_ID GNAME GOWNER
REPCAT$_FLAVOR_OBJECTS_FK1_IDX	NORMAL	NONUNIQUE	SYSTEM	GNAME GOWNER
REPCAT$_FLAVOR_OBJECTS_FK2_IDX	NORMAL	NONUNIQUE	SYSTEM	GNAME FLAVOR_ID GOWNER

Foreign Keys

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

Columns

Name	Datatype	Length	Mandatory	Comments
FLAVOR_ID	NUMBER		Yes	Flavor identifier
GOWNER	VARCHAR2	(128)	Yes	Owner of the object group containing object
GNAME	VARCHAR2	(30)	Yes	Object group containing object
SNAME	VARCHAR2	(128)	Yes	Schema containing object
ONAME	VARCHAR2	(128)	Yes	Name of object
TYPE	NUMBER		Yes	Object type
COLUMNS_PRESENT	RAW	(125)		For tables, encoded mapping of columns present
HASHCODE	RAW	(17)		Hashcode of a user-defined type
VERSION#	NUMBER			Version# of a user-defined type

Query Text

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


SELECT FLAVOR_ID
,      GOWNER
,      GNAME
,      SNAME
,      ONAME
,      TYPE
,      COLUMNS_PRESENT
,      HASHCODE
,      VERSION#
FROM SYSTEM.REPCAT$_FLAVOR_OBJECTS;

Dependencies

[top of page]

SYSTEM.REPCAT$_FLAVOR_OBJECTS does not reference any database object

SYSTEM.REPCAT$_FLAVOR_OBJECTS is referenced by following:

SYS: DBA_REPFLAVOR_OBJECTS; DBMS_OFFLINE_RGT_INTERNAL - 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_RQ - show dependent code; DBMS_REPCAT_UTL - show dependent code; DBMS_REPCAT_UTL4 - show dependent code; REPCAT_REPFLAVOR_COLUMNS; _ALL_REPFLAVOR_OBJECTS