ORA-37133: (XSCCOMP08) Cannot write into an aggregated
VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the
CLEAR AGGREGATES command to reenable write access.



ORA-37133: (XSCCOMP08) Cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSI..

Answer / guest

Cause: The user attempted to store a value into to a
variabled dimensioned by a compressed composite, and the
variable had previously been precomputed using the AGGREGATE
command. Once the AGGREGATE command is run on a variable
dimensioned by a compressed composite, it 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-17624: Failed to delete directory string

1 Answers  


DRG-12305: column string data type is not supported for index set columns

1 Answers  


ORA-13371: invalid position of measure dimension

1 Answers  


ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified

1 Answers  


ORA-27508: IPC error sending a message

1 Answers  






ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

1 Answers  


DGM-16902: Unable to allocate handle

1 Answers  


IMP-00057: Warning: Dump file may not contain data of all partitions of this table

1 Answers  


PLS-00352: Unable to access another database 'string'

1 Answers  


ORA-04062: %s of string has been changed

1 Answers  


ORA-39047: Jobs of type string cannot use multiple execution streams.

1 Answers  


ORA-25118: invalid DUMP DATAFILE/TEMPFILE option

1 Answers  


Categories