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

ORA-13906: The tablepace is not of the right type.

1 Answers  


ORA-13182: failed to read element string.string.string

1 Answers  


TNS-01099: %s * string * string * string * number

1 Answers  


ORA-07700: sksarch: interrupt received

1 Answers  


ORA-31612: Allocation of process descriptor failed.

1 Answers  






ORA-24028: cannot create a reciever non-repudiable single consumer queue

1 Answers  


ORA-22162: element at index [string] has been previously deleted

1 Answers  


PCC-02103: Password:

1 Answers  


RMAN-06194: target database instance not started

1 Answers  


ORA-14113: partitioned table cannot have column with LOB datatype

1 Answers  


TNS-04002: The command completed successfully.

1 Answers  


ORA-00025: failed to allocate string

1 Answers  


Categories