ORA-32306: updatable materialized views with user-defined
types must use SELECT *



ORA-32306: updatable materialized views with user-defined types must use SELECT *..

Answer / guest

Cause: An attempt was made to create an updatable
materialized view with user-defined types 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-00664: VM Node-Stack overflow.

1 Answers  


QSM-02003: aggregate function nested within an expression

1 Answers  


EXP-00004: invalid username or password

1 Answers  


ORA-09915: Password encryption failed.

1 Answers  


TNS-00209: Tracing : string

1 Answers  






ORA-33304: (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.

1 Answers  


LRM-00122: value 'string' for 'string' must be between 'number' and 'number'

1 Answers  


ORA-01308: initialization parameter utl_file_dir is not set

2 Answers  


ORA-16015: log string sequence# string not archived, media recovery disabled

1 Answers  


PCC-02337: cannot declare multi-dimensioned array for this type

1 Answers  


ORA-01142: cannot end online backup - none of the files are in backup

1 Answers  


ORA-23464: flavor lacks column string of "string"."string"

1 Answers  


Categories