ORA-39281: Cannot alter COMPRESS in index-organized materialized view.

ORA-39281: Cannot alter COMPRESS in index-organized materialized view.
Cause: DBMS_METADATA_DIFF was comparing two index organized materialized views with different key compression values. There is no SQL ALTER statement to modify the key compression of an index organized materialized view.
Action: The difference cannot be eliminated with an SQL ALTER statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:52

ORA-39281：无法在索引组织的物化视图中更改COMPRESS。,
.原因： DBMS_METADATA_DIFF正在比较具有不同键压缩值的两个索引组织的物化视图。没有SQL ALTER语句来修改索引组织的物化视图的密钥压缩。,
.操作：使用SQL ALTER语句无法消除该差异。,
.

aiaiDBA

13718043309

010-86462881

ORA-39281: Cannot alter COMPRESS in index-organized materialized view.

1 个回答

相似问题