重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE [打印本页]

作者: michaeljet 时间: 2016-9-7 09:43
标题: ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE

ORA-37130: (XSCCOMP05) Cannot aggregate overCOMPRESSED COMPOSITE

workspace object usingAGGMAP workspace object becauseyou must specify

AGGINDEX OFF when there is a PRECOMPUTEclause on a RELATION over

base workspace object.

Cause: A PRECOMPUTE clause wasspecified in the AGGMAP for a RELATION

over a base of a COMPRESSED COMPOSITE, but AGGINDEX wasON

Action: Remove the PRECOMPUTE clausefrom the AGGMAP, or add

AGGINDEX OFF

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)