文档解释
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子句重建表空间。