I'm creating a materialized view and having the following problems:
When I create the view with ENABLE QUERY REWRITE option I get the this error message: ORA-01031: insufficient privileges. I tried this: GRANT REWRITE ON 'table_name' TO 'user' while connected as user sys but was still getting the error. I also tried this command (with GLOBAL): GRANT GLOBAL QUERY REWRITE but the SQL*Plus kept returning an error message: ORA-00990: missing or invalid privilege.
What I really want to do is to create a materialized view that will on refresh increamentally after laoding data. I'm sure someone out there has done this before me so PLEASE HELP!!!
[Edited by ac on 05-30-2001 at 08:08 AM]
I guess I'm not the first person to handle materialized view so can somebody out there help please!!!?
Click Here to Expand Forum to Full Width