tune_mview privilege issue
I tried to verify created mview and did following:
variable mytask varchar2(2000);
BEGIN
DBMS_ADVISOR.TUNE_MVIEW (:mytask,
'CREATE MATERIALIZED VIEW join_4group_mv
BUILD IMMEDIATE REFRESH FAST ON COMMIT ENABLE QUERY REWRITE
AS
select pn.first_name, pn.last_name, re.name, re.ethnic_group from person pn,
race re where pn.race_id=re.id');
END;
/
PL/SQL procedure successfully completed.
set long 30000
set pagesize 3000
set linesize 132
select * from user_tune_mview;
Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view
SP2-0612: Error generating AUTOTRACE EXPLAIN report
I have resource role and advisor system privilege and select object privilege, but don't konw why got the error message. Then I did that:
execute dbms_advisor.execute_task('mytask');
BEGIN dbms_advisor.execute_task('mytask'); END;
*
ERROR at line 1:
ORA-13605: The specified task or object mytask does not exist for the current user.
ORA-06512: at "SYS.PRVT_ADVISOR", line 1283
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at line 1
Does any one could give a hint? Thanks,