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]

VIEW: SYS.USER_REPFLAVORS

Object Details

Object Name:	USER_REPFLAVORS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Flavors current user created for replicated object groups

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FLAVOR_ID	NUMBER		Yes	Flavor identifier, unique within 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	VARCHAR2	(128)	Yes	User that created the flavor
PUBLISHED	VARCHAR2	(1)		Indicates whether flavor is published (Y/N) or obsolete (O)
GROUP_OWNER	VARCHAR2	(128)		Owner of the object group

Query Text

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


SELECT FLAVOR_ID
,      GNAME
,      FNAME
,      CREATION_DATE
,      CREATED_BY
,      PUBLISHED
,      GROUP_OWNER
FROM SYS.USER_REPFLAVORS;

Dependencies

[top of page]

SYS.USER_REPFLAVORS references the following:

SYS: USER$
SYSTEM: REPCAT$_FLAVORS

SYS.USER_REPFLAVORS is referenced by following:

PUBLIC: USER_REPFLAVORS