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>