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-01160: file is not a string

1 Answers  


DRG-12516: language column must be specified when using the multi stoplist

1 Answers  


ORA-01274: cannot add datafile 'string' - file could not be created

1 Answers  


RMAN-04020: target database name "string" does not match channel's name: "string"

1 Answers  


ORA-31495: error in synchronous change table on "string"."string"

1 Answers  






ORA-30152: File does not exist

1 Answers  


ORA-31610: cannot call this function from a non-master process

1 Answers  


RMAN-06571: datafile number does not have recoverable copy

1 Answers  


ORA-22856: cannot add columns to object tables

2 Answers  


ORA-29893: indextypes without column data do not need the given data type

1 Answers  


ORA-01626: rollback segment number 'string' cannot handle more transactions

1 Answers  


ORA-30736: objects in a table or view hierarchy have to be in the same schema

1 Answers  


Categories