truncate分区以后，物化视图快速刷新出错
drop分区以后，物化视图快速刷新出错
测试Oralce9i的情况:
SQL> create table T_PART
2 (
3 C1 NUMBER,
4 C2 NUMBER,
5 C3 NUMBER
6 )
7 partition by range (C2)
8 (
9 partition T_P2 values less than (20)
10 ,
11 partition T_P3 values less than (30)
12 )
13 ;
Table created.
SQL> insert into t_part values(1,2,3);
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
---------- ---------- ----------
1 2 3
1 18 3
1 25 3
SQL> select * from mv_t_part;
C1 C2 C3
---------- ---------- ----------
1 2 3
1 18 3
1 25 3
SQL> alter table t_part truncate partition t_p2;
Table truncated.
SQL> exec dbms_mview.refresh("mv_t_part","f");
BEGIN dbms_mview.refresh("mv_t_part","f"); END;
*
责任编辑：小草
您现在的位置： 