ORA-32413: allow concurrent refresh of materialized view and truncate
Cause: This event is set to allow concurrent refresh of materialized view and truncate of base table; it prevents a deadlock situation. (bug 6710019)
Action: Set this event to allow concurrent refresh of materialized view and truncate of the base table.
ORA-32413: allow concurrent refresh of materialized view and truncate
这是Oracle的一条错误消息,通常当我们尝试同时刷新一个材料视图(Materialized Views)和截断表时会收到。
ORA-32413:当尝试在TRUNCATE或DROP表时指定REFRESH选项,将出现这个错误消息。
当我们尝试在TRUNCATE或DROP表时指定REFRESH选项时,将出现这个错误消息。
1、刷新材料视图:
SELECT DBMS_MVIEW.REFRESH(‘MVIEW_NAME’,’C’,’Y’,’Y’,’Y’);
2、截断表:
TRUNCATE TABLE TABLE_NAME;
本文标签:ORA-32413 allow concurrent refresh of materialized view and truncate
原文链接:
版权说明: 本文由作者上传,本站仅提供存储服务,转载请注明原文链接