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

LPX-00277: no closing quote was seen

1 Answers  


ORA-30555: global index partitioning key is an expression

1 Answers  


SQL*Loader-00200: FORMAT clause should not be present - flat data files only

1 Answers  


QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

1 Answers  


ORA-31044: Top-level prefix length string exceeds maximum string

1 Answers  






LSX-00014: empty instance document

1 Answers  


RMAN-05017: no copy of datafile number found to recover

0 Answers  


PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type

1 Answers  


ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

1 Answers  


SQL-02124: NULL value returned by EXEC TOOLS statement

1 Answers  


NNO-00604: disabling all request processing

1 Answers  


SQL*Loader-02026: the load was aborted because SQL Loader cannot continue.

1 Answers  


Categories