ORA-32304: materialized views with user-defined types cannot
use prebuilt table



ORA-32304: materialized views with user-defined types cannot use prebuilt table..

Answer / guest

Cause: An attempt was made to create a materialized view
with the ON PREBUILT TABLE option.

Action: Do not create the materialized view with the ON
PREBUILT TABLE option.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02761: File number to be canceled is negative.

1 Answers  


ORA-24811: less data provided for writing than indicated

1 Answers  


ORA-34183: (MXCHGDCL22) Partition number already exists.

1 Answers  


ORA-06540: PL/SQL: compilation error

1 Answers  


NZE-28768: bad magic number

1 Answers  






ORA-00824: cannot set sga_target due to existing internal settings

1 Answers  


ORA-13362: disjoint sub-element in a compound polygon

1 Answers  


SQL*Loader-00274: At least 2 read buffers have to be specified.

1 Answers  


ORA-27007: failed to open file

1 Answers  


ORA-38403: attribute set name may not be longer than 22 characters

1 Answers  


ORA-27213: failed to unload Media Management Library

1 Answers  


ORA-28106: input value for argument #string is not valid

1 Answers  


Categories