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._ALL_REPFLAVOR_OBJECTS

Object Details

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

Replicated objects in flavors

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FLAVOR_ID	NUMBER		Yes	Flavor identifier
GNAME	VARCHAR2	(30)	Yes	Object group name
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
PUBLISHED	VARCHAR2	(1)		Indicates whether flavor is published (Y/N) or obsolete (O)
FLAG	RAW	(4)		Information about replicated object
GOWNER	VARCHAR2	(128)	Yes	Object group owner
VERSION#	NUMBER			Object type version#
HASHCODE	RAW	(17)		Object type hashcode

Query Text

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


SELECT FLAVOR_ID
,      GNAME
,      SNAME
,      ONAME
,      TYPE
,      COLUMNS_PRESENT
,      PUBLISHED
,      FLAG
,      GOWNER
,      VERSION#
,      HASHCODE
FROM SYS._ALL_REPFLAVOR_OBJECTS;

Dependencies

[top of page]

SYS._ALL_REPFLAVOR_OBJECTS references the following:

SYS: ALL_OBJECTS; XML_SCHEMA_NAME_PRESENT - show dependent code
SYSTEM: REPCAT$_FLAVORS; REPCAT$_FLAVOR_OBJECTS; REPCAT$_REPOBJECT

SYS._ALL_REPFLAVOR_OBJECTS is referenced by following:

SYS: DBMS_REPCAT_RGT_CUST - show dependent code