Home » Server Options » Replication » create materialized view + insufficient privileges (Oracle 8.1.7.4)
create materialized view + insufficient privileges [message #300236] Thu, 14 February 2008 12:03 Go to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

CREATE MATERIALIZED VIEW Matview1
NOLOGGING
NOCACHE
NOPARALLEL
REFRESH COMPLETE ON DEMAND
START WITH sysdate
NEXT sysdate + 1
WITH ROWID
ENABLE QUERY REWRITE AS
select Query;

if i run select query it works fine .. also the user has create materialized view and query rewrite privs .. not sure why i am getting insufficient privileges error still ..

Can you tell me what is missing here ..
Re: create materialized view + insufficient privileges [message #300241 is a reply to message #300236] Thu, 14 February 2008 12:18 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post the complete error message/code.
Previous Topic: materialized View Error : existing state of packages has been discarded
Next Topic: how to alter materialized view object
Goto Forum:
  


Current Time: Thu Mar 28 17:54:26 CDT 2024