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.
The 'F' parameter indicates a fast refresh. But will it work without an MV log on the table?
Refresh all materialized view with :
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11083/viewspace-159255/，如需转载，请注明出处，否则将追究法律责任。