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_REPGENOBJECTS

Object Details

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

Objects generated to support replication

[View Source]

Columns

Name	Datatype	Length	Comments
SNAME	VARCHAR2	(128)	Schema containing the generated object
ONAME	VARCHAR2	(128)	Name of the generated object
TYPE	VARCHAR2	(12)	Type of the generated object
BASE_SNAME	VARCHAR2	(128)	Name of the object's owner
BASE_ONAME	VARCHAR2	(128)	Name of the object
BASE_TYPE	VARCHAR2	(12)	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
REASON	VARCHAR2	(30)	Reason the object was generated

Query Text

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


SELECT SNAME
,      ONAME
,      TYPE
,      BASE_SNAME
,      BASE_ONAME
,      BASE_TYPE
,      PACKAGE_PREFIX
,      PROCEDURE_PREFIX
,      DISTRIBUTED
,      REASON
FROM SYS.ALL_REPGENOBJECTS;

Dependencies

[top of page]

SYS.ALL_REPGENOBJECTS references the following:

SYS: ALL_OBJECTS; ALL_USERS; REPCAT_GENERATED; REPCAT_REPOBJECT; USER_REPGENOBJECTS; USER_REPGROUP_PRIVILEGES; UTL_RAW - show dependent code; XML_SCHEMA_NAME_PRESENT - show dependent code

SYS.ALL_REPGENOBJECTS is referenced by following:

PUBLIC: ALL_REPGENOBJECTS
SYS: DBMS_REPCAT_UTL - show dependent code; DBMS_REPUTIL - show dependent code