ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Partition Change-Tracking Without MV Logs

Partition Change-Tracking Without MV Logs

原创 Linux操作系统 作者:mkcvictor 时间:2019-05-23 08:48:05 0 删除 编辑
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;
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11083/viewspace-159255/,如需转载,请注明出处,否则将追究法律责任。

全部评论

注册时间:2002-05-07

  • 博文量
    29
  • 访问量
    22084