ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.

ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
Cause: A PRECOMPUTE clause was specified in the AGGMAP for a RELATION over a base of a COMPRESSED COMPOSITE, but AGGINDEX was ON
Action: Remove the PRECOMPUTE clause from the AGGMAP, or add AGGINDEX OFF

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37130：（XSCCOMP05）无法使用AGGMAP工作空间对象在COMPRESSED COMPOSITE工作空间对象上进行聚合，因为当在基础工作空间对象上的RELATION上存在PRECOMPUTE子句时，必须指定AGGINDEX OFF 。,
.原因：在AGGMAP中为COMPRESSED COMPOSITE的基础上的RELATION指定了PRECOMPUTE子句，但AGGINDEX为ON,
.操作：从AGGMAP中删除PRECOMPUTE子句，或者添加AGGINDEX OFF,
.

aiaiDBA

13718043309

010-86462881

ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.

1 个回答

相似问题