oracle可更新的物化视图,可更新物化视图，如何更新原表？

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

PL/SQL Release 10.2.0.1.0 - Production

CORE    10.2.0.1.0      Production

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

SQL>

SQL> drop table t;

表已删除。

SQL> create table t as

2    select object_id id, object_name name from user_objects;

表已创建。

SQL>

SQL>  select count(*) from t;

COUNT(*)

----------

22979

SQL>  create materialized view log on t with rowid;

实体化视图日志已创建。

SQL>  create materialized view mv_t refresh fast with rowid for update as

2     select * from t;

实体化视图已创建。

SQL> select count(*) from mv_t;

COUNT(*)

----------

22979

SQL>

SQL> insert into mv_t values (1, 'aa');

已创建 1 行。

SQL>

SQL> insert into mv_t values (1, 'aa');

已创建 1 行。

SQL>

SQL> commit;

提交完成。

SQL> select count(*) from mv_t;

COUNT(*)

----------

22981

SQL>

SQL> select count(*) from t;

COUNT(*)

----------

22979

SQL> select count(*) from t;

COUNT(*)

----------

22979

SQL>   exec dbms_mview.refresh('MV_T');

PL/SQL 过程已成功完成。

SQL> select count(*) from t;

COUNT(*)

----------

22979

SQL> select count(*) from mv_t;

COUNT(*)

----------

22979

SQL>