今天Kamus在Gtalk上让我帮忙测试,是关于物化视图的:
- truncate分区以后,物化视图快速刷新出错
- drop分区以后,物化视图快速刷新出错
测试Oralce9i的情况:
SQL> create table T_PART Table created. 1 row created. SQL> insert into t_part values(1,25,3); 1 row created. SQL> insert into t_part values(1,18,3); 1 row created. SQL> commit; Commit complete. SQL> create materialized view log on t_part with rowid; Materialized view log created. SQL> create materialized view mv_t_part refresh with rowid as select * from t_part; Materialized view created. SQL> select * from t_part; C1 C2 C3 SQL> select * from mv_t_part; C1 C2 C3 SQL> alter table t_part truncate partition t_p2; Table truncated. SQL> exec dbms_mview.refresh('mv_t_part','f');* |
这里出现错误。
ORA-32313 REFRESH FAST of "string"."string" unsupported after PMOPs
Cause: A Partition Maintenance Operation (PMOP) has been performed on a detail table, and the specified materialized view does not support fast refersh after PMOPs.
Action: Use REFRESH COMPLETE. You can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API.
再来测试Oracle10g的:
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




