Help needed regarding Materialized view [message #274182] |
Sun, 14 October 2007 22:58 |
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
|
|
|
|
|