Fortunately, in Oracle Database 10g Release 2, PCT works without the need for MV logs.
Let's see this in action. First, confirm that there is no MV log on the table ACCOUNTS.
SQL> select *
2 from dba_mview_logs
3 where master = 'ACCOUNTS';
Refresh the materialized view ACC_VIEW using fast refresh.
execute dbms_mview.refresh('ACC_VIEW','F')
The 'F' parameter indicates a fast refresh. But will it work without an MV log on the table?
Refresh all materialized view with :
execute dbms_mview.REFRESH_ALL_MVIEWS;
Let's see this in action. First, confirm that there is no MV log on the table ACCOUNTS.
SQL> select *
2 from dba_mview_logs
3 where master = 'ACCOUNTS';
Refresh the materialized view ACC_VIEW using fast refresh.
execute dbms_mview.refresh('ACC_VIEW','F')
The 'F' parameter indicates a fast refresh. But will it work without an MV log on the table?
Refresh all materialized view with :
execute dbms_mview.REFRESH_ALL_MVIEWS;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11083/viewspace-159255/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11083/viewspace-159255/