| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
ALL_REFRESH_CHILDREN describes all the objects in refresh groups that are accessible to the current user.
DBA_REFRESH_CHILDREN describes the objects in all refresh groups in the database.
USER_REFRESH_CHILDREN describes the objects in all refresh groups owned by the current user.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
OWNER | 
VARCHAR2(30) | 
NOT NULL | 
Owner of the object in the refresh group | 
NAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of the object in the refresh group | 
TYPE | 
VARCHAR2(30) | 
Type of the object in the refresh group | |
ROWNER | 
VARCHAR2(30) | 
NOT NULL | 
Owner of the refresh group | 
RNAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of the refresh group | 
REFGROUP | 
NUMBER | 
Internal identifier of the refresh group | |
IMPLICIT_DESTROY | 
VARCHAR2(1) | 
Indicates whether the refresh group is destroyed when its last item is subtracted (Y) or not (N) | 
|
PUSH_DEFERRED_RPC | 
VARCHAR2(1) | 
Indicates whether changes are pushed from the snapshot to the master before refresh (Y) or not (N) | 
|
REFRESH_AFTER _ERRORS | 
VARCHAR2(1) | 
Indicates whether to proceed with refresh despite errors when pushing deferred RPCs (Y) or not (N) | 
|
ROLLBACK_SEG | 
VARCHAR2(30) | 
Name of the rollback segment to use while refreshing | |
JOB | 
NUMBER | 
Identifier of the job used to refresh the group automatically | |
NEXT_DATE | 
DATE | 
Date that this job will next be refreshed automatically, if not broken | |
INTERVAL | 
VARCHAR2(200) | 
A date function used to compute the next NEXT_DATE | 
|
BROKEN | 
VARCHAR2(1) | 
Indicates whether the job is broken and will never be run (Y) or not (N) | 
|
PURGE_OPTION | 
NUMBER(38) | 
Method for purging the transaction queue after each push. 1 indicates quick purge option; 2 indicates precise purge option | 
|
PARALLELISM | 
NUMBER(38) | 
Level of parallelism for transaction propagation | |
HEAP_SIZE | 
NUMBER(38) | 
Size of the heap |