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

ORA-16718: failed to locate the database resource

1 Answers  


TNS-00214: Total Connections in Use : number

1 Answers  


SQL*Loader-02050: Multibyte character error.

1 Answers  


ORA-24378: user callbacks not allowed for this call

1 Answers  


ORA-00439: feature not enabled: string

1 Answers  






ORA-09801: Unable to get user ID from connection

1 Answers  


ORA-13158: Oracle object string does not exist

1 Answers  


ORA-30505: system triggers should not reference a column in a WHEN clause

1 Answers  


PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

2 Answers  


ORA-01126: database must be mounted in this instance and not open in any instance

1 Answers  


NNL-00950: Cache lookup requests: number

1 Answers  


ORA-14106: LOGGING/NOLOGGING may not be specified for a clustered table

1 Answers  


Categories