Hi,
I want to create a materialized view based on Views. is it possible to do this.
I get a error 'ORA-01031: insufficient privileges' when i try to execute the query.
Regards
bensmail
Printable View
Hi,
I want to create a materialized view based on Views. is it possible to do this.
I get a error 'ORA-01031: insufficient privileges' when i try to execute the query.
Regards
bensmail
What is the perceived benefit in do that rather than using what the view is based on to generate the MV?
Do you have privileges on the view's underlying objects?
do you have the "create materialized view" privilege?