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

TNS-01179: Listener cannot load instance class "string"

1 Answers  


ORA-02057: 2PC: string: bad two-phase recovery state number string from string

1 Answers  


ORA-12853: insufficient memory for PX buffers: current stringK, max needed stringK

1 Answers  


ORA-40262: NMF: number of features not between [1, string]

1 Answers  


ORA-26026: unique index string.string initially in unusable state

0 Answers   Forbis, VC,






ORA-24182: attribute number specified does not exist

1 Answers  


TNS-01304: ns secondary err code: number

1 Answers  


ORA-02851: Request list is empty when it should not be

1 Answers  


LPX-00014: context is not clean

1 Answers  


ORA-32140: cannot peform this operation on stream

1 Answers  


ORA-24851: failed to connect to shared subsystem

1 Answers  


TNS-02521: encryption/crypto-checksumming: Diffie-Hellman seed too small

1 Answers  


Categories