Saturday 2 June 2012

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

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.

No comments:

Post a Comment