-
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.
Nagesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|