Database Tuning (MOSC)

MOSC Banner

Materialized view not refreshing automatically after import

edited Jun 9, 2011 11:21PM in Database Tuning (MOSC) 1 commentAnswered
 Hi,

Materialized views are not refreshing automatically after import.

Giving error in alert log

ORA-12012: error on auto execute of job 515
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

I have already given

grant execute on DBMS_SNAPSHOT to user

grant execute on DBMS_IREFRESH  to user

grant execute on DBMS_REFRESH to user

Please suggest.

BR///

nk

PS: The export and import was done by system user.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center