| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
ALL_REFRESH describes all the refresh groups accessible to the current user.
Related Views
DBA_REFRESH describes all refresh groups in the database.
USER_REFRESH describes all refresh groups owned by the current user.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
ROWNER | 
VARCHAR2(30) | 
NOT NULL | 
Name of the owner of the refresh group | 
RNAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of the refresh group | 
REFGROUP | 
NUMBER | 
Internal identifier of refresh group | |
IMPLICIT_DESTROY | 
VARCHAR2(1) | 
(Y |N) If Y, then destroy the refresh group when its last item is subtracted | 
|
PUSH_DEFERRED_RPC | 
VARCHAR2(1) | 
(Y |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(30) | 
Name of the rollback segment to use while refreshing | |
JOB | 
NUMBER | 
Identifier of 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) | 
(Y |N) Y means the job is broken and will never be run | 
|
PURGE_OPTION | 
NUMBER(38) | 
The method for purging the transaction queue after each push. 1 indicates quick purge option; 2 indicates precise purge option | 
|
PARALLELISM | 
NUMBER(38) | 
The level of parallelism for transaction propagation | |
HEAP_SIZE | 
NUMBER(38) | 
The size of the heap |