ORA-32413: allow concurrent refresh of materialized view and truncate

文档解释

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;

你可能感兴趣的