ORA-01031

问题

create materialized view

oerr ora 01031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to perform a database operation without
//         the necessary privileges.
// *Action: Ask your database administrator or designated security
//          administrator to grant you the necessary privileges

解决方案

GRANT CREATE VIEW TO USER；

grant create materialized view to user;
grant create any materialized view to user;
grant global query rewrite to user;
grant on commit refresh to user;
grant create view to user;
grant create table to user;