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-39029: worker string with process name "string" prematurely terminated

1 Answers  


IMP-00006: failed to allocate memory of size number

1 Answers  


NZE-29040: There are no supported cipher suites.

1 Answers  


NID-00600: Internal Error - [number] [number] [number] [number]

1 Answers  


RMAN-06220: Creating automatic instance

1 Answers  


ORA-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.

1 Answers  


ORA-03297: file contains used data beyond requested RESIZE value

1 Answers  


PLS-01707: In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

1 Answers  


ORA-31199: Warning in processing file string

1 Answers  


LSX-00231: invalid unsigned integer "~S"

1 Answers  


ORA-09882: sstasfre/sstasdel: shmctl error, unable to remove tas shm page

1 Answers  


ORA-25527: bad format of _DB_MTTR_SIM_TARGET

1 Answers  


Categories