oracle aide

September 24, 2007

DBMS_MVIEW.REFRESH fails with ORA-01031

Filed under: mview, replication — Tags: , , — oracleaide @ 8:15 pm

Problem statement:

  • user_a owns a materialized view (mv_demo);
  • user_b wants to refresh the mv_demo mview in the user_a schema;
  • dbms_refresh fails with ORA-01031: insufficient privileges.
  • (more…)

    Blog at WordPress.com.