DBMS_MVIEW v15
Use procedures in the DBMS_MVIEW package to manage and refresh materialized views and their dependencies. EDB Postgres Advanced Server provides support for the following DBMS_MVIEW procedures:
| Procedure | Return type | Description |
|---|---|---|
GET_MV_DEPENDENCIES(list VARCHAR2, deplist VARCHAR2); | n/a | The GET_MV_DEPENDENCIES procedure returns a list of dependencies for a specified view. |
REFRESH(list VARCHAR2, method VARCHAR2, rollback_seg VARCHAR2 , push_deferred_rpc BOOLEAN, refresh_after_errors BOOLEAN , purge_option NUMBER, parallelism NUMBER, heap_size NUMBER , atomic_refresh BOOLEAN , nested BOOLEAN); | n/a | This variation of the REFRESH procedure refreshes all views named in a comma-separated list of view names. |
REFRESH(tab dbms_utility.uncl_array, method VARCHAR2, rollback_seg VARCHAR2, push_deferred_rpc BOOLEAN, refresh_after_errors BOOLEAN, purge_option NUMBER, parallelism NUMBER, heap_size NUMBER, atomic_refresh BOOLEAN, nested BOOLEAN); | n/a | This variation of the REFRESH procedure refreshes all views named in a table of dbms_utility.uncl_array values. |
REFRESH_ALL_MVIEWS(number_of_failures BINARY_INTEGER, method VARCHAR2, rollback_seg VARCHAR2, refresh_after_errors BOOLEAN, atomic_refresh BOOLEAN); | n/a | The REFRESH_ALL_MVIEWS procedure refreshes all materialized views. |
REFRESH_DEPENDENT(number_of_failures BINARY_INTEGER, list VARCHAR2, method VARCHAR2, rollback_seg VARCHAR2, refresh_after_errors BOOLEAN, atomic_refresh BOOLEAN, nested BOOLEAN); | n/a | This variation of the REFRESH_DEPENDENT procedure refreshes all views that depend on the views listed in a comma-separated list. |
REFRESH_DEPENDENT(number_of_failures BINARY_INTEGER, tab dbms_utility.uncl_array, method VARCHAR2, rollback_seg VARCHAR2, refresh_after_errors BOOLEAN, atomic_refresh BOOLEAN, nested BOOLEAN); | n/a | This variation of the REFRESH_DEPENDENT procedure refreshes all views that depend on the views listed in a table of dbms_utility.uncl_array values. |
EDB Postgres Advanced Server's implementation of DBMS_MVIEW is a partial implementation when compared to Oracle's version. Only those functions and procedures listed in the table are supported.
get_mv_dependencies refresh refresh_all_mviews refresh_dependent