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