ORA-30354: Query rewrite not allowed on SYS relations

ORA-30354: Query rewrite not allowed on SYS relations
Cause: A SYS relation was referenced in the select clause for a materialized view with query rewrite enabled.
Action: Remove the reference to the SYS relation from the select clause or disable the REWRITE option on the materialized view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30354：不允许在SYS关系上进行查询重写,
.原因：在启用查询重写的实例化视图的select子句中引用了SYS关系。,
.操作：从select子句中删除对SYS关系的引用，或禁用物化视图上的REWRITE选项。,
.

aiaiDBA

13718043309

010-86462881

ORA-30354: Query rewrite not allowed on SYS relations

1 个回答

相似问题