文档解释 ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV Cause: the table on which
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。
--结束END--
本文标题: ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV ORACLE 报错
本文链接: https://lsjlt.com/news/532793.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
官方手机版
微信公众号
商务合作
0