如何创建物化视图？？？

[Delphi_Li]

我写了如下的创建语句
Create Materialized View Vi_Current_Invest_Value
Build Immediate
Refresh On Commit
Enable Query Rewrite As
Select A.Gsm, Sum( Nvl( B.Mny, 0 ) )
From Gsmcard A, Gsmbnkop B
Where ( A.Vcdid = B.Vcdid ) And
( B.Cd In( '0001', '0012', '0013', '0014', '0015' ) ) And
( To_Char( B.Dt, 'YYYYMM' ) = To_Char( Sysdate, 'YYYYMM' ) )
Group By A.Gsm

并且用户拥有以下的权限：
Connect
Resource
Query Rewrite
但是我没有找到Create Materialized View权限，数据库是Oracle 8i EE(8.1.7) For Micorsoft Windows，以上的语句就是不能创建物化视图！！！高手错在哪里呢？？？

[bzszp]

To create a materialized view in your own schema, you must have the CREATE SNAPSHOT or CREATE MATERIALIZED VIEW, CREATE TABLE, CREATE INDEX, and CREATE VIEW system privileges.

To create a materialized view in another user's schema, you must have the CREATE ANY SNAPSHOT or CREATE ANY MATERIALIZED VIEW system privilege.

[Drate]

你需要CREATE MATERIALIZED VIEW的权限或是CREATE SNAPSHOT的权限才可进行操作!

[Delphi_Li]

我没有找到Create Materialized View是不是在Oracle 8i中Create Materialized View就是Create Snapshot？？？

[qiuyang_wang]

直接创建SNAPSHOT就可以了，在oracle8i中还没有物化视图的说法。
需要权限：CREATE SNAPSHOT

[beckhambobo]

9i --物化视图
8i --快照(8.1.7以支持物化视图)

叫法不同，两者相同作用
9i:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_63a.htm#2063795
8.1.5以下版本:
http://download-west.oracle.com/docs/cd/F49540_01/DOC/index.htm