ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Limitation of PCT (Partition Change Tracking)

Limitation of PCT (Partition Change Tracking)

原创 Linux操作系统 作者:jeffli73 时间:2009-08-03 00:08:09 0 删除 编辑
Mview log is needed for mview fast refresh.It records every changed row.But for Partition Maintenance Operations (PMOPS) such as alter partition, drop partition, truncate partition, etc, the mview log does't record these information.In order to keep the materialized view consistence with master table(or base table) and avoid complete refresh,since Oracle server version 9i,Oracle can take advantage of PCT (Partition Change Tracking) mechanism to do a fast_pct refresh.
Although fast_pct refresh will not refresh all rows of a table,it will refresh all rows related to the changed partitions.
But there are some limitations of fast_pct.PCT is not supported over database links.If the materialized view is distributed (i.e. the master table and the materialized view are located on different databases) then an ORA-12034( Materialized View Log Younger than Last Refresh) error is expected after PMOPS to force a complete refresh. Another limitation is the top level partition key must consist of only a single column.

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

请登录后发表评论 登录
全部评论

注册时间:2009-06-10

  • 博文量
    21
  • 访问量
    53930