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

NNL-00348: Server saving the config file now

1 Answers  


ORA-19650: Offline-range record recid string stamp string in file string has SCN string

1 Answers  


ORA-14018: partition bound list contains too few elements

1 Answers  


NNO-00806: Error: OCI_ERROR: string

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  






QSM-01602: equivalence, string, requires join back to table, string, on column, string

1 Answers  


ORA-08230: smscre: failed to allocate SGA

1 Answers  


SQL*Loader-00940: UPI error while setting NCHAR bind attributes for column string table string

1 Answers  


RMAN-06746: backup cancelled because all files were skipped

1 Answers  


ORA-08447: syntax error in USAGE clause in mask options

1 Answers  


CLSR-00512: Invalid CAA trigger event type [string]

1 Answers  


PCC-00078: FIPS warning: Invalid ANSI SQL Identifier

1 Answers  


Categories