Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

RMAN-08104: input backupset count=string stamp=string creation_time=string

1 Answers  


ORA-00023: session references process private memory; cannot detach session

2 Answers  


ORA-33100: (APABBR02) Value 'number' is not valid for the workspace object option.

1 Answers  


ORA-36677: (XSDPART15) Duplicate value in value lists of number and number

1 Answers  


ORA-38716: Must supply an integer for the TYPE option.

1 Answers  


ORA-30005: missing or invalid WAIT interval

1 Answers  


QSM-02044: ORDER BY clause in mv

1 Answers  


RMAN-20004: target database name does not match name in recovery catalog

1 Answers  


ORA-04093: references to columns of type LONG are not allowed in triggers

1 Answers  


ORA-16509: the request timed out

1 Answers  


IMP-00059: Failure to initialize parameter manager

1 Answers  


ORA-23357: the propagator does not exist

2 Answers  


Categories