ORA-32334: cannot create prebuilt materialized view on a table already referenc

ORA-32334: cannot create prebuilt materialized view on a
table already referenced by a MV

Question Posted / guest

1 Answers
6459 Views
I also Faced
E-Mail Answers

ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV..

Answer / guest

Cause: the table on which the materialized view is created
as prebuilt is already referenced by a materialized view

Action: create the materialized view on a different table

Please add more information about this Error

Is This Answer Correct ?

1 Yes

4 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00487: Invalid reference to variable 'string'

1 Answers

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

1 Answers

ORA-00017: session requested to set trace event

1 Answers

ORA-29967: Cannot drop an operator binding with dependent objects

1 Answers

ORA-01617: cannot mount: string is not a valid thread number

1 Answers

NNO-00120: line string: topology name "string" not allowed here

1 Answers

ORA-33012: (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.

1 Answers

PLS-00127: Pragma string is not a supported pragma

1 Answers

IMG-00820: area 0 queue clear failed

1 Answers

PCC-02316: illegal operator in constant expression

1 Answers

ORA-15026: disk 'string' is not an ASM disk

1 Answers

TNS-01027: Listener Trace File string

1 Answers

For more Oracle Errors Interview Questions Click Here