Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PCC-02361: Use of ARRAYLEN with SQL bind arrays is ignored

1 Answers  


ORA-36820: (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.

1 Answers  


NNL-00810: Queries received with no type: number

1 Answers  


ORA-13415: invalid or out of scope point specification

1 Answers  


RMAN-06479: WARNING: control file copy 'string' cannot be found on disk

1 Answers  






ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running

1 Answers  


RMAN-06179: datafile number not processed because file is read-only

1 Answers  


ORA-24804: Lob read/write functions called while another OCI LOB read/write streaming is in progress

1 Answers  


RMAN-06160: no backup pieces found for backup set key: number

1 Answers  


ORA-01619: thread string is mounted by another instance

1 Answers  


ORA-30625: method dispatch on NULL SELF argument is disallowed

1 Answers  


TNS-00540: SSL protocol adapter failure

1 Answers  






Categories