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_REPGENOBJECTS

Object Details

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

Objects generated for the current user to support replication

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SNAME	VARCHAR2	(128)	Yes	Schema containing the generated object
ONAME	VARCHAR2	(128)	Yes	Name of the generated object
TYPE	VARCHAR2	(12)		Type of the generated object
BASE_SNAME	VARCHAR2	(128)	Yes	Name of the user
BASE_ONAME	VARCHAR2	(128)	Yes	Name of the user's object
BASE_TYPE	VARCHAR2	(12)		Type of the user's 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.USER_REPGENOBJECTS;

Dependencies

[top of page]

SYS.USER_REPGENOBJECTS references the following:

SYS: REPCAT_GENERATED; USER_USERS

SYS.USER_REPGENOBJECTS is referenced by following:

PUBLIC: USER_REPGENOBJECTS
SYS: ALL_REPGENOBJECTS