Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.