ORA-37134: (XSCCOMP09) You cannot add new values to
workspace object because it includes positions for
precomputed aggregate values.
- 1 Answers
- 1974 Views
- I also Faced
- E-Mail Answers
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 |
ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
ORA-36972: (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
ORA-01941: SEQUENCE keyword expected
PCC-02315: cannot evaluate expression as constant
ORA-06970: X.25 Driver: remote host is unknown
NNL-00980: Forwarding failures: number
ORA-15023: reached maximum allowable number of disks string
ORA-14621: cannot add subpartition when DEFAULT subpartition exists
ORA-27301: OS failure message: string
DRG-51803: failed to open file: %(1)
ORA-02763: Unable to cancel at least one request
ORA-01643: system tablespace can not be made read only
Oracle Errors 
