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.
需要权限:CREATE SNAPSHOT
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