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_REFRESH_CHILDREN

Object Details

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

All the objects in refresh groups, where the user owns the refresh group

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the object in the refresh group
NAME	VARCHAR2	(128)	Yes	Name of the object in the refresh group
TYPE	VARCHAR2	(128)		Type of the object in the refresh group
ROWNER	VARCHAR2	(128)	Yes	Name of the owner of the refresh group
RNAME	VARCHAR2	(128)	Yes	Name of the refresh group
REFGROUP	NUMBER			Internal identifier of refresh group
IMPLICIT_DESTROY	VARCHAR2	(1)		Y or N, if Y then destroy the refresh group when its last item is subtracted
PUSH_DEFERRED_RPC	VARCHAR2	(1)		Y or N, if Y then push changes from snapshot to master before refresh
REFRESH_AFTER_ERRORS	VARCHAR2	(1)		If Y, proceed with refresh despite error when pushing deferred RPCs
ROLLBACK_SEG	VARCHAR2	(128)		Name of the rollback segment to use while refreshing
JOB	NUMBER			Identifier of job used to automatically refresh the group
NEXT_DATE	DATE			Date that this job will next be automatically refreshed, if not broken
INTERVAL	VARCHAR2	(200)		A date function used to compute the next NEXT_DATE
BROKEN	VARCHAR2	(1)		Y or N, Y is the job is broken and will never be run
PURGE_OPTION	NUMBER			The method for purging the transaction queue after each push
PARALLELISM	NUMBER			The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER			The heap size used for transaction propagation

Query Text

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


SELECT OWNER
,      NAME
,      TYPE
,      ROWNER
,      RNAME
,      REFGROUP
,      IMPLICIT_DESTROY
,      PUSH_DEFERRED_RPC
,      REFRESH_AFTER_ERRORS
,      ROLLBACK_SEG
,      JOB
,      NEXT_DATE
,      INTERVAL
,      BROKEN
,      PURGE_OPTION
,      PARALLELISM
,      HEAP_SIZE
FROM SYS.USER_REFRESH_CHILDREN;

Dependencies

[top of page]

SYS.USER_REFRESH_CHILDREN references the following:

SYS: DBA_REFRESH_CHILDREN; USER$

SYS.USER_REFRESH_CHILDREN is referenced by following:

PUBLIC: USER_REFRESH_CHILDREN