SQL> conn hrdwrite/password; Connected. SQL> BEGIN DBMS_MVIEW.REFRESH(LIST=>'HIFIND.PERSON', method=>'c'); END; 2 / BEGIN DBMS_MVIEW.REFRESH(LIST=>'HIFIND.PERSON', method=>'c'); END; * ERROR at line 1: 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_SNAPSHOT", line 2426 ORA-06512: at line 1
解决办法: grant ALTER ANY MATERIALIZED VIEW to hrdwrite。
SQL> conn /as sysdba Connected. SQL> grant ALTER ANY MATERIALIZED VIEW to hrdwrite 2 ;