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 IN..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38609: FI Not enough memory for tree counting, requires at least stringKB

1 Answers  


PCC-00075: ":" expected before indicator variable

1 Answers  


ORA-24036: invalid SORT_ORDER column string specified for queue table

1 Answers  


ORA-13150: failed to insert exception record

1 Answers  


ORA-00276: CHANGE keyword specified but no change number given

1 Answers  






ORA-15014: location 'string' is not in the discovery set

1 Answers  


ORA-01527: error while reading file

1 Answers  


ORA-03201: the group number specification is invalid

1 Answers  


PLS-00310: with %%ROWTYPE attribute, 'string' must name a table, cursor or cursor-variable

1 Answers  


ORA-38456: The attribute set "string" is in an inconsistent state.

1 Answers  


ORA-19612: datafile string not restored due to string

1 Answers  


ORA-29377: consumer group string is not part of top-plan string

1 Answers  


Categories