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

TNS-12623: TNS:operation is illegal in this state

1 Answers  


NZE-28798: Number of sub-keys application passes to bind does not match that in the key.

1 Answers  


RMAN-06135: error executing host command: string

1 Answers  


ORA-01804: failure to initialize timezone information

2 Answers  


TNS-00303: Connection Manager: Reread parameter data

1 Answers  






TNS-12659: Error received from other process

1 Answers  


ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications

1 Answers  


ORA-22951: NULL returned by ORDER method

1 Answers  


TNS-00542: SSL Handshake failed

1 Answers  


ORA-24128: partition name specified for a non-partitioned object

1 Answers  


NZE-28794: data type attribute did not initialize

1 Answers  


ORA-10919: Default temporary tablespace group must have at least one tablespace

1 Answers  


Categories