Home » Server Options » Replication » Help needed regarding Materialized view
Help needed regarding Materialized view [message #274182] Sun, 14 October 2007 22:58 Go to next message
jobsushil
Messages: 7
Registered: October 2007
Location: India
Junior Member
Hi,
I am getting the following error when i try to refresh the materialized view.

execute DBMS_SNAPSHOT.REFRESH( 'mv_stored_proc_3','C');

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1



Kindly help me out.


regards
Job
Re: Help needed regarding Materialized view [message #274189 is a reply to message #274182] Sun, 14 October 2007 23:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't have qufficient privileges to refresh this MV.

Regards
Michel
Re: Help needed regarding Materialized view [message #275920 is a reply to message #274182] Tue, 23 October 2007 06:39 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


May i know your user name and privilege.

Babu



Previous Topic: Help with creating fast updating materialised view
Next Topic: Materialized View Refresh
Goto Forum:
  


Current Time: Thu Mar 28 16:35:17 CDT 2024