ORA-37134: (XSCCOMP09) You cannot add new values to
workspace object because it includes positions for
precomputed aggregate values.



ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions ..

Answer / guest

Cause: The user attempted to create a new position in a
compressed composite, either directly (using MAINTAIN MERGE
or MAINTAIN ADD) or by storing a value into the variable
dimensioned by the compressed composite. This is not allowed
when the variable has been precomputed using the AGGREGATE
command. Once the AGGREGATE command is run on a variable
dimensioned by a compressed composite, the compressed
composite becomes read-only until the computed values are
removed with the CLEAR command.

Action: Run the CLEAR AGGREGATES command to remove the
computed values from the variable and then rerun the failed
operation. Note that CLEAR AGGREGATES will remove all the
data computed during the last AGGREGATE command on this
variable.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-34357: (MXDSS10) string is not an alias of analytic workspace string.

1 Answers  


RMAN-06056: could not access datafile number

1 Answers  


RMAN-06177: restore not done; all files readonly, offline, or already restored

1 Answers  


NZE-29034: Correct cipher suite or client authentication is needed.

1 Answers  


ORA-30333: dimension does not exist

1 Answers  






PCC-02402: Pro*C option OBJECTS=YES is required when using the object cache

1 Answers  


QSM-01509: equivalence, string, matched query text

1 Answers  


EXP-00006: internal inconsistency error

1 Answers  


QSM-02180: no primary key constraint in the master table

1 Answers  


ORA-15047: ASM file name 'string' is not in multiple-file creation form

1 Answers  


ORA-01974: Illegal archive option

1 Answers  


DRG-11820: Unauthorized

1 Answers  


Categories