ORA-32308: object materialized views must use SELECT *



ORA-32308: object materialized views must use SELECT *..

Answer / guest

Cause: An attempt was made to create an object materialized
view where the definition query did not use SELECT * at the
topmost level.

Action: Rewrite the definition query so that SELECT * is
used at the topmost level.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00712: Internal error: bad address for big endian UTF16 conversion

1 Answers  


ORA-25195: invalid option for index on an index-organized table

1 Answers  


ORA-26563: renaming this table is not allowed

1 Answers  


NNL-00853: Renames refused, new name already exists: number

1 Answers  


KUP-03005: relative end (number) specified does not match fieldlen(number) for field string

1 Answers  


ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints

1 Answers  


ORA-01265: Unable to delete string string

1 Answers  


ORA-16576: failed to update Data Guard configuration file

1 Answers  


ORA-28163: GRANT already specified

1 Answers  


ORA-14060: data type or length of a table partitioning column may not be changed

1 Answers  


ORA-00485: DIAG process terminated with error string

1 Answers  


ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher

1 Answers  


Categories