ORA-32315: REFRESH FAST of "string"."string"

michaeljet

ORA-32315: REFRESH FAST of "string"."string"unsupported after mixed DML and

Direct Load

Cause: One or more of thematerialized view logs on the detail tables referenced

by the specified materialized view omits the sequencenumber option. Such a log

cannot be used to refresh a materialized view afterdeletes or updates and direct

path insert.

Action: Use REFRESH COMPLETE. Note:you can use the DBMS_

MVIEW.EXPLAIN_MVIEW() API to determine which materializedview logs omit

the sequence number option.