ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV
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
:
ORA-32334 错误是由于一张表已经被一个MV所引用,而试图在这张表上创建一个预建MV。该错误表明在一张表上,只允许创建一个MV,不允许两个MV同时引用一张表。
正常处理:在建立MV之前,需要先检查一个表上是否有其他MV,如果有,则必须先删除旧MV,再创建新MV。