Error in Creating Materialized Views

[barnard90]

I am trying to create a Materialized view Emp_view
But I am getting this error .
hr is the name of the schema where I want to create the view.

create materialized view hr.Emp_view for UPDATE as select * from hr.Employee
*
ERROR at line 1:
ORA-01031: insufficient privileges

Could some one please suggest the remedy

Thanks

 

[Dagon]

Do you have the privilege to create materialized views/snapshots ? There is a specific system privilege for it - "create snapshot".

 

[barnard90]

Dagon
Thanks for your post

I do not have any previlige on it
How do I have previliges granted on my name ?
Please suggest.

 

[Dagon]

Log on as a DBA and grant them to yourself (grant create snapshot to xxx). If you don't have DBA access, contact the DBA.