Oracle Database Errors or Warnings from Error ORA-32307 to ORA-32316

SQLServerF1

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.
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.
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.

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.
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.
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.

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.
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.
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-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.

Above are list of Oracle Database Errors or Warnings from Error ORA-32307 to ORA-32316 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *