sys用户下不允许创建物化视图

SQL> conn /as sysdba
Connected.
SQL>
SQL>
SQL> create table t(x int);

Table created.

SQL> insert into t values (1);

1 row created.

SQL> insert into t values (2);

1 row created.

SQL> /

1 row created.

SQL> commit;

Commit complete.

SQL> select * from t;

         X
----------
         1
         2
         2

3 rows selected.

SQL> select * from t group by x;

         X
----------
         1
         2

2 rows selected.

SQL> CREATE MATERIALIZED VIEW LOG ON t WITH SEQUENCE, ROWID
(x) INCLUDING NEW VALUES;
  2
Materialized view log created.

SQL> CREATE MATERIALIZED VIEW t_mv
BUILD IMMEDIATE
REFRESH fast on commit
ENABLE QUERY REWRITE AS
SELECT * from t GROUP BY x;
  2    3    4    5  SELECT * from t GROUP BY x
              *
ERROR at line 5:
ORA-30354: Query rewrite not allowed on SYS relations

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23898243/viewspace-696094/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23898243/viewspace-696094/