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-00380: cannot specify db_stringk_cache_size since stringK is the standard block size

1 Answers  


ORA-31693: Table data object string failed to load/unload and is being skipped due to error: string

1 Answers  


EXP-00040: Dump file and log file must be different

1 Answers  


ORA-22874: attribute "string" is not part of the type "string"

1 Answers  


ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  






ORA-02365: error seeking in file: string

1 Answers  


RMAN-06004: ORACLE error from recovery catalog database: string

1 Answers  


DRG-12504: stoplist string does not exist

1 Answers  


ORA-03208: partitioned type must be specified for a non-composite object

1 Answers  


ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

1 Answers  


DRG-51021: undefined error in fuzzy matcher

1 Answers  


ORA-16771: Converting physical standby to primary failed in the failover operation.

1 Answers  


Categories