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…)

    September 19, 2007

    “Create materialized view” fails on a remote view.

    Filed under: fun, replication — oracleaide @ 4:22 pm

    An attempt to create a materialized view fails if the master object is a remote view.
    The error is ORA-00942, table or view does not exist.
    This happens when the remote view is not owned by the database link user. In my case:

    create database link demo_db_link connect to MVADMIN identified by MVADMIN
    


    (more…)

    Blog at WordPress.com.