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:

ProcedureReturn typeDescription
GET_MV_DEPENDENCIES(list VARCHAR2, deplist VARCHAR2);n/aThe 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/aThis 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/aThis 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/aThe 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/aThis 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/aThis 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