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

Oracle Error Message

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

Reason for the Error

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

Solution

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