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 or N ; if Y , then destroy the refresh group when its last item is removed |
PUSH_DEFERRED_RPC |
VARCHAR2(1) |
|
Y or N ; if Y , then push changes from materialized view to masters before refresh |
REFRESH_AFTER _ERRORS |
VARCHAR2(1) |
|
Y or N ; if Y , then proceed with refresh despite error when pushing deferred remote procedure calls (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 the 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 or N ; if Y , then the job is broken and will never run |
PURGE_OPTION |
NUMBER(38) |
|
The method for purging the transaction queue after each push. 1 is quick purge option. 2 is precise purge option. |
PARALLELISM |
NUMBER(38) |
|
The level of parallelism for transaction propagation. Zero indicates serial propagation. 1 or higher indicates parallel propagation. |
HEAP_SIZE |
NUMBER(38) |
|
The size of the heap |