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-14623: Value string does not exist in subpartition string

1 Answers  


SQL*Loader-00137: Invalid value for RESUMABLE_TIMEOUT

1 Answers  


TNS-01072: Started at string

1 Answers  


ORA-13378: invalid index for element to be extracted

1 Answers  


ORA-23476: cannot import from string to string

1 Answers  






QSM-01089: an inline view in the query does not have a materialized view

1 Answers  


TNS-00215: Total Successful Connections : number

1 Answers  


NNO-00709: failed delete of cache checkpoint file "string", cache flush may not work

1 Answers  


TNS-00501: Cannot allocate memory

1 Answers  


TNS-04016: Connecting to string

1 Answers  


NNL-00525: Shows or sets the server's default-forwarding status

1 Answers  


ORA-08180: no snapshot found based on specified time

1 Answers  


Categories