建立Materialized VIEW所需的Oracle權限

grant SELECT ANY TABLE to oracle;

grant CREATE MATERIALIZED VIEW to oracle;

grant CREATE ANY VIEW to oracle;

grant CREATE ANY MATERIALIZED VIEW to oracle;

grant CREATE ANY TABLE to oracle;

grant CREATE SESSION to oracle;

grant GLOBAL QUERY REWRITE to oracle;

grant create any materialized view to oracle;

 

Grant succeeded.

 

SQL>

 

 

SQL>conn oracle/oracle

CREATE MATERIALIZED VIEW "ORACLE"."TEST_MV"

refresh complete

ENABLE QUERY REWRITE

AS

select xxx from xxx where ….;