DBMS_MVIEW.REFRESH Fails With ORA-01031

最新推荐文章于 2023-09-27 16:13:22 发布

原创最新推荐文章于 2023-09-27 16:13:22 发布 · 914 阅读

1 ·

CC 4.0 BY-SA版权

Oracle 专栏收录该内容

56 篇文章

订阅专栏

本文介绍了解决在Oracle数据库中，当尝试刷新其他用户拥有的物化视图时遇到的ORA-01031权限不足错误的方法。通过授予ALTER ANY MATERIALIZED VIEW权限给需要刷新视图的用户，可以有效解决这一问题。

部署运行你感兴趣的模型镜像

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.

Example:

SQL> exec dbms_mview.refresh('user_a.mv_demo');
BEGIN dbms_mview.refresh('user_a.mv_demo'); END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429
ORA-06512: at line 1

Solution:

grant ALTER ANY MATERIALIZED VIEW to user_b.

您可能感兴趣的与本文相关的镜像