Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-38456: The attribute set "string" is in an inconsistent state.

1 Answers  


ORA-24156: duplicate table alias string

1 Answers  


TNS-00226: Unable to contact pump number to send broadcast message string

1 Answers  


ORA-01169: DATAFILE number 1 not found. Must be present

1 Answers  


ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.

1 Answers  






DRG-51313: timeout while waiting for DML or optimize lock

1 Answers  


PCC-00079: ANSI requires colon on label in WHENEVER statement

1 Answers  


ORA-08429: raw data has invalid digit in display type data

1 Answers  


PLS-00229: Attribute expression within SQL expression

1 Answers  


ORA-39112: Dependent object type string skipped, base object type string creation failed

1 Answers  


ORA-16622: Two or more broker database objects resolve to one physical database.

1 Answers  


DRG-10525: missing REBUILD keyword

1 Answers  






Categories