Hi

When I try to create materialized views I am getting the following error : ORA-01031: insufficient privileges

Here is the script I am using :

create materialized view cdr_hourly
as
SELECT TO_CHAR(START_TIME,'HH24') hours, COUNT(*) noofrecs
FROM CDR
WHERE START_TIME >= SYSDATE-10 AND START_TIME <= SYSDATE+31
AND SERVICE_TYPE = 2
AND DIRECTION='O'
GROUP BY TO_CHAR(START_TIME,'HH24');

I granted GLOBAL QUERY REWRITE and
QUERY REWRITE privileges. No DBA role. In order to create MV what should be the minimum requirements. Do I need to set any init.ora parameters? Do I need to grant DBA role?

Please advice.