Database Error Messages

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