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

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 have been performed on multiple detail tables

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates

Cause: One or more deletes or updates has been performed on one or more of the detail tables referenced by the specified materialized view. This materialized view does not support fast refresh after deletes or updates

Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after deletes or updates using the DBMS_MVIEW.EXPLAIN_MVIEW() API

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32313: REFRESH FAST of "string"."string" unsupported after PMOPs

Cause: A Partition Maintenance Operation (PMOP) has been performed on a detail table, and the specified materialized view does not support fast refersh after PMOPs

Action: Use REFRESH COMPLETE. Note: you can determine why your materialized view does not support fast refresh after PMOPs using the DBMS_MVIEW.EXPLAIN_MVIEW() API

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32312: cannot refresh a secondary materialized view "string"."string"

Cause: An attempt was made to refresh a materialized view of a nested table column's storage table

Action: Refresh the materialized view that contains the nested table column. This will implicitly refresh all secondary materialized views

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32311: materialized view definition query selects an unsupported user-defined type

Cause: An attempt was made in the definition query to select an embedded user-defined type, function returning a user-defined type, or a function whose arguments are user-defined types

Action: Rewrite the definition query to exclude these unsupported user-defined types

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32310: object materialized views must select from an object table

Cause: An attempt was made to create an object materialized view whose definition query did not select from an object table

Action: Rewrite the definition query to select from an object table

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32309: object mview type "string"."string" does not match the master table type

Cause: An attempt was made to create an object materialized view whose type does not match the type of the master object table

Action: Redefine the type so that it matches the type of the master object table

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32308: object materialized views must use SELECT *

Cause: An attempt was made to create an object materialized view where the definition query did not use SELECT * at the topmost level

Action: Rewrite the definition query so that SELECT * is used at the topmost level

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-32307: must use FROM ONLY clause when referencing an object table

Cause: An attempt was made to create a materialized view whose definition query references object tables without the FROM ONLY clause

Action: Rewrite the definition query to use the FROM ONLY clause for all the object tables in the query

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/