ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
Cause: The user attempted to assign a value to a dimension surrogate whose data type is INTEGER. INTEGER surrogates, like INTEGER dimensions, cannot have values assigned to them. They can only be referenced by position.
Action: Do not attempt to assign values to an INTEGER surrogate. Values will automatically appear and disappear from the INTEGER surrogate as positions are added to or removed from the underlying dimension.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-34143：（MXCGPUT02）不能将值分配给SURROGATE工作空间对象，因为它的类型为INTEGER。,
.原因：用户尝试为数据类型为INTEGER的维替代项分配值。INTEGER代理，如INTEGER维，不能有值分配给它们。它们只能通过位置引用。,
.操作：不要尝试为INTEGER代理指定值。值将自动出现并从INTEGER代理中消失，因为向底层维添加或删除了位置。,
.

aiaiDBA

13718043309

010-86462881

ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 个回答

相似问题