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

标题: ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because [打印本页]

作者: michaeljet 时间: 2016-9-7 09:44
标题: ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because

ORA-37134: (XSCCOMP09) You cannot add newvalues to workspace object because

it includes positions for precomputedaggregate values.

Cause: The user attempted to create anew position in a compressed composite,

either directly (using MAINTAIN MERGE or MAINTAIN ADD) orby storing a

value into the variable dimensioned by the compressedcomposite. This is not

allowed when the variable has been precomputed using theAGGREGATE

command. Once the AGGREGATE command is run on a variabledimensioned by

a compressed composite, the compressed composite becomesread-only until the

computed values are removed with the CLEAR command.

Action: Run the CLEAR AGGREGATEScommand to remove the computed

values from the variable and then rerun the failedoperation. Note that CLEAR

AGGREGATES will remove all the data computed during thelast AGGREGATE

command on this variable.

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