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

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。

你可能感兴趣的