ORA-32315: REFRESH FAST of “string”.”string” unsupported after mixed DML and Direct Load

文档解释

ORA-32315: REFRESH FAST of “string”.”string” unsupported after mixed DML and Direct Load

Cause: One or more of the materialized view logs on the detail tables referenced by the specified materialized view omits the sequence number option. Such a log cannot be used to refresh a materialized view after deletes or updates and direct path insert.

Action: Use REFRESH COMPLETE. Note: you can use the DBMS_MVIEW.EXPLAIN_MVIEW() API to determine which materialized view logs omit the sequence number option.

ORA-32315: REFRESH FAST of “string”.”string” unsupported after mixed DML and Direct Load 该错误表示,在进行混合的DML(数据库操纵语言)操作和直接装载以后,不支持“字符串”。 “字符串”的快速刷新。

官方解释

ORA-32315表示在混合的DML操作和直接载入以后,保留表空间中不支持字符串字段的快速刷新操作。

常见案例

当客户尝试执行直接装载和混合DML系统操作(插入,更新或删除)以后,他可能会遇到ORA-32315错误。

一般处理方法及步骤

1.一定要执行清理DML操作,以清理混合的DML操作和直接装载操作;

2.检查表空间是否正确配置,以确保表空间和索引空间在自动收缩;

3.用group by子句重建表空间。

你可能感兴趣的