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-02017: unable to open output file

1 Answers  


PLS-00171: duplicate dedicated AGENT specification in subprogram expression

1 Answers  


PROC-00026: Error while accessing the physical storage

1 Answers  


QSM-02019: mv references another mv in FROM clause

1 Answers  


ORA-21615: copy of an OTS (named or simple) instance failed

1 Answers  






IMG-00711: unable to set properties of destination image

1 Answers  


DRG-10101: no value for argument: string

1 Answers  


ORA-02067: transaction or savepoint rollback required

1 Answers  


ORA-16072: a minimum of one standby database destination is required

1 Answers  


ORA-25259: cannot specify protocol for agent

1 Answers  


ORA-22926: specified trim length is greater than current LOB value's length

1 Answers  


ORA-37013: (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.

1 Answers  


Categories