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.