UNREGISTER_MVIEW Used to unregister a materialized view at a master site or
master materialized view site.
TABLE 17-1 DBMS_MVIEW Subprograms
Chapter 17: Managing Distributed Databases 617
To refresh a single materialized view, use DBMS_MVIEW.REFRESH. Its two main parameters
are the name of the materialized view to be refreshed and the method to use. For the method,
you can specify ???c??™ for a complete refresh, ???f??™ for fast refresh, and ??????™ for force. Here??™s an example:
execute DBMS_MVIEW.REFRESH('store_dept_sal_mv','c');
If you are refreshing multiple materialized views via a single call to DBMS_MVIEW.REFRESH,
list the names of all the materialized views in the first parameter and their matching refresh
methods in the second parameter, as in this example:
execute DBMS_MVIEW.REFRESH('mv1,mv2,mv3','cfc');
In this example, the materialized view MV2 will be refreshed via a fast refresh, whereas the other
will use a complete refresh.
You can use a separate procedure in the DBMS_MVIEW package to refresh all the materialized
views that are scheduled to be automatically refreshed. This procedure, named REFRESH_ALL,
will refresh each materialized view separately. It does not accept any parameters. The following
listing shows an example of its execution:
execute DBMS_MVIEW.REFRESH_ALL;
Because the materialized views will be refreshed via REFRESH_ALL consecutively, they are
not all refreshed at the same time (in other words, not in parallel).
Pages:
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908