Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22163: left hand and right hand side collections are not of same type

1 Answers  


ORA-13208: internal error while evaluating [string] operator

1 Answers  


TNS-12532: TNS:invalid argument

4 Answers  


EXP-00038: Bad Hash cluster id in clu$

1 Answers  


ORA-02881: sou2o: Could not revoke access to protected memory

1 Answers  






QSM-01046: complex join back on correlated columns not allowed (string)

1 Answers  


ORA-01096: program version (string) incompatible with instance (string)

1 Answers  


ORA-01779: cannot modify a column which maps to a non key-preserved table

1 Answers  


ORA-13636: The specified value string provided for parameter string is not valid for this advisor.

1 Answers  


ORA-22878: duplicate LOB partition or subpartition specified

1 Answers  


ORA-02333: cannot create constraints on attributes of this column

1 Answers  


SQL-02113: Unable to open message file

1 Answers  






Categories