Oracle Error ORA-37108: (XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.

Oracle Error Message

ORA-37108: (XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.

Reason for the Error

An attempt was made to add a partition to a partitioned variable. Either the partition was defined WITH AGGCOUNT and the partitioned variable was not, or the partitioned variable was defined WITH AGGCOUNT and the partition was not.

Solution

Use CHGDFN ADD AGGCOUNT or CHGDFN DROP AGGCOUNT to either add or remove an AGGCOUNT from either the partition or the partitioned variable.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...