有两篇网上的文章结合着看比较好

http://www.chinaitpower.com/A/2002-05-02/21578.html

提供了笼统的mv的概貌介绍

http://yangtingkun.itpub.net/post/468/11356

提供了定义物化视图的子句的详细介绍

http://dev.csdn.net/article/45/45638.shtm

有些权限说明及注意问题

自己也做了个简单测试：见内

[@more@]

需要主键

cycker> create materialized view mv_robincui refresh fast on commit with primary key as select * from robincui;
create materialized view mv_robincui refresh fast on commit with primary key as select * from robincui
*
ERROR at line 1:
ORA-12014: table 'ROBINCUI' does not contain a primary key constraint

cycker> alter table robincui add primary key PK_TEST (TEST);
alter table robincui add primary key PK_TEST (TEST)
*
ERROR at line 1:
ORA-00906: missing left parenthesis

cycker> alter table robincui add primary key (TEST);

Table altered.

需要MV LOG对基表

cycker> create materialized view mv_robincui refresh fast on commit with primary key as select * from robincui;
create materialized view mv_robincui refresh fast on commit with primary key as select * from robincui
*
ERROR at line 1:
ORA-23413: table "ROBIN"."ROBINCUI" does not have a materialized view log

cycker> CREATE MATERIALIZED VIEW LOG ON robincui;

Materialized view log created.

cycker> create materialized view mv_robincui refresh fast on commit with primary key as select * from robincui;

Materialized view created.

cycker> select * from mv_robincui;

TEST
--------------------
test1
test2

cycker> select * from robincui;

TEST
--------------------
test1
test2

cycker> insert into robincui values('test3');

1 row created.

cycker> select * from mv_robincui;

TEST
--------------------
test1
test2

cycker> commit;

Commit complete.

cycker> select * from mv_robincui;

TEST
--------------------
test1
test2
test3

增加字段，MV没有更新

cycker> alter table robincui add (TEST_COL2 varchar(10));

Table altered.

cycker> select * from mv_robincui;

TEST
--------------------
test1
test2
test3

cycker> select * from robincui;

TEST TEST_COL2
-------------------- ----------
test1
test2
test3

cycker> update robincui set test_col2 = 'TEST';

3 rows updated.

cycker> commit;

Commit complete.

cycker> select * from mv_robincui;

TEST
--------------------
test1
test2
test3

cycker> insert into robincui values('test4','TEST1');

1 row created.

cycker> commit;

Commit complete.

cycker> select * from mv_robincui;

TEST
--------------------
test1
test2
test3
test4