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



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

ORA-01157: cannot identify/lock data file string - see DBWR trace file

1 Answers  


LPX-00662: Invalid encoding.

1 Answers  


SQL*Loader-00800: %s specified and ignored

1 Answers  


PCB-00316: SQL FORMS statements are Oracle extensions

1 Answers  


ORA-31530: could not find published column string for CDC subscriber view string.string

1 Answers  






ORA-16511: messaging error using ksrget

1 Answers  


ORA-21301: not initialized in object mode

1 Answers  


TNS-12623: TNS:operation is illegal in this state

1 Answers  


ORA-31634: job already exists

1 Answers  


ORA-27016: skgfcls: sbtinfo returned error

1 Answers  


RMAN-11005: conflicting media information for piece "string"

1 Answers  


NID-00372: Change database ID and database name string to string? (Y/[N]) =>

1 Answers  


Categories