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

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

Question Posted / guest

1 Answers
3723 Views
I also Faced
E-Mail Answers

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

SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number

1 Answers

ORA-32700: error occurred in DIAG Group Service

1 Answers

ORA-16531: unable to post message

1 Answers

ORA-25117: MIN/MAX/Block Number expected

1 Answers

NID-00132: CHECKPOINT_CHANGE# in datafile "string": string in the future of controlfile: string

1 Answers

ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.

1 Answers

ORA-09310: sclgt: error freeing latch

1 Answers

RMAN-06053: unable to perform media recovery because of missing log

1 Answers

ORA-27190: skgfrd: sbtread2 returned error

1 Answers

NNC-00431: NS address does not match any of the current addresses

1 Answers

ORA-16080: invalid LogMiner session string for APPLY

1 Answers

PCC-00145: This statement can only be used with THREADS=YES

1 Answers

For more Oracle Errors Interview Questions Click Here