The REFRESH procedure refreshes the specified materialized view.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_MVIEW.REFRESH (
{ list IN VARCHAR2,
| tab IN DBMS_UTILITY.UNCL_ARRAY,}
method IN VARCHAR2 := NULL,
rollback_seg IN VARCHAR2 := NULL,
push_deferred_rpc IN BOOLEAN := true,
refresh_after_errors IN BOOLEAN := false,
purge_option IN BINARY_INTEGER := 1,
parallelism IN BINARY_INTEGER := 0,
heap_size IN BINARY_INTEGER := 0,
atomic_refresh IN BOOLEAN := true,
nested IN BOOLEAN := false,
out_of_place IN BOOLEAN := false,
skip_ext_data IN BOOLEAN := false,
refresh_parallel IN BINARY_INTEGER := 1);
Parameters
| Parameter | Description |
|---|---|
| list | The list of names of materialized views to be refreshed, which are separated with commas (,). You can specify only one materialized view at a time in the current version. |
| tab | The array of names of materialized views to be refreshed. You can specify only one materialized view at a time in the current version. |
| method | The refresh strategy for the materialized view. You can specify a default strategy when you create a materialized view. Valid values:
|
| rollback_seg | This parameter is reserved only for compatibility with Oracle. |
| push_deferred_rpc | This parameter is reserved only for compatibility with Oracle. |
| refresh_after_errors | This parameter is reserved only for compatibility with Oracle. |
| purge_option | This parameter is reserved only for compatibility with Oracle. |
| parallelism | This parameter is reserved only for compatibility with Oracle. |
| heap_size | This parameter is reserved only for compatibility with Oracle. |
| atomic_refresh | This parameter is reserved only for compatibility with Oracle. |
| nested | This parameter is reserved only for compatibility with Oracle. |
| out_of_place | This parameter is reserved only for compatibility with Oracle. |
| skip_ext_data | This parameter is reserved only for compatibility with Oracle. |
| refresh_parallel | The number of threads that execute the refresh operation at the same time. |