REFRESH v11
Use the REFRESH
procedure to refresh all views specified in either a comma-separated list of view names, or a table of DBMS_UTILITY.UNCL_ARRAY
values. The procedure has two signatures; use the first form when specifying a comma-separated list of view names:
REFRESH( <list> IN VARCHAR2, <method> IN VARCHAR2 DEFAULT NULL, <rollback_seg> IN VARCHAR2 DEFAULT NULL, <push_deferred_rpc> IN BOOLEAN DEFAULT TRUE, <refresh_after_errors> IN BOOLEAN DEFAULT FALSE, <purge_option> IN NUMBER DEFAULT 1, <parallelism> IN NUMBER DEFAULT 0, <heap_size> IN NUMBER DEFAULT 0, <atomic_refresh> IN BOOLEAN DEFAULT TRUE, <nested> IN BOOLEAN DEFAULT FALSE);
Use the second form to specify view names in a table of DBMS_UTILITY.UNCL_ARRAY
values:
REFRESH( <tab> IN OUT DBMS_UTILITY.UNCL_ARRAY, <method> IN VARCHAR2 DEFAULT NULL, <rollback_seg> IN VARCHAR2 DEFAULT NULL, <push_deferred_rpc> IN BOOLEAN DEFAULT TRUE, <refresh_after_errors> IN BOOLEAN DEFAULT FALSE, <purge_option> IN NUMBER DEFAULT 1, <parallelism> IN NUMBER DEFAULT 0, <heap_size> IN NUMBER DEFAULT 0, <atomic_refresh> IN BOOLEAN DEFAULT TRUE, <nested> IN BOOLEAN DEFAULT FALSE);
Parameters
list
list
is a VARCHAR2
value that specifies the name of a materialized view, or a comma-separated list of materialized view names. The names may be schema-qualified.
tab
tab
is a table of DBMS_UTILITY.UNCL_ARRAY
values that specify the name (or names) of a materialized view.
method
method
is a VARCHAR2
value that specifies the refresh method that will be applied to the specified view (or views). The only supported method is C
; this performs a complete refresh of the view.
rollback_seg
rollback_seg
is accepted for compatibility and ignored. The default is NULL
.
push_deferred_rpc
push_deferred_rpc
is accepted for compatibility and ignored. The default is TRUE
.
refresh_after_errors
refresh_after_errors
is accepted for compatibility and ignored. The default is FALSE
.
purge_option
purge_option
is accepted for compatibility and ignored. The default is 1
.
parallelism
parallelism
is accepted for compatibility and ignored. The default is 0
.
heap_size IN NUMBER DEFAULT 0
,
heap_size
is accepted for compatibility and ignored. The default is 0
.
atomic_refresh
atomic_refresh
is accepted for compatibility and ignored. The default is TRUE
.
nested
nested
is accepted for compatibility and ignored. The default is FALSE
.
Examples
The following example uses DBMS_MVIEW.REFRESH
to perform a COMPLETE
refresh on the public.emp_view
materialized view:
EXEC DBMS_MVIEW.REFRESH(list => 'public.emp_view', method => 'C');