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

PLS-00316: PL/SQL TABLEs must use a single index

1 Answers  


ORA-16011: Archivelog Remote File Server process in Error state

1 Answers  


SQL*Loader-00521: lfilini failed for file (string)

1 Answers  


ORA-24132: table name string is too long

2 Answers  


ORA-09844: soacon: Archmon unable to open named pipe.

1 Answers  






ORA-32828: Messaging Gateway agent must be running

1 Answers  


ORA-14257: cannot move partition other than a Range or Hash partition

1 Answers  


ORA-07609: szprv: $HASH_PASSWORD failure

1 Answers  


ORA-33036: (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.

1 Answers  


SQL*Loader-00414: no columns to load for table string

1 Answers  


ORA-30572: AUTO segment space management not valid with DICTIONARY extent management

1 Answers  


PCB-00635: This attribute is only valid for Internal LOB types

1 Answers  


Categories