ORA-36164: (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).

ORA-36164: (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
Cause: The user specified a COUNTVAR clause to the AGGREGATE command, but the number of COUNTVAR variables specified did not match the number of variables to be aggregated
Action: Specify a separate COUNTVAR for each variable

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-36164：（XSMXAGGR07）使用COUNTVAR子句时，要聚合的变量数（数字）必须与COUNTVAR变量（数字）的数量相匹配。,
.原因：用户为AGGREGATE命令指定了COUNTVAR子句，但是指定的COUNTVAR变量的数量与要聚合的变量的数量不匹配,
.操作：为每个变量指定单独的COUNTVAR,
.

aiaiDBA

13718043309

010-86462881

ORA-36164: (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).

1 个回答

相似问题