Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_REFRESH
describes all the refresh groups accessible to the current user.
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 |