Oracle Error Message
ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV
Reason for the Error
the table on which the materialized view is created as prebuilt is already referenced by a materialized view
Solution
create the materialized view on a different table