How to fix the Oracle error ORA-37123: (XSCCOMP17) Can not AGGREGATE workspace object(partition number) because it depends on unaggregated compressed partition number.?

In this post, you’ll learn more about the Oracle ErrorORA-37123: (XSCCOMP17) Can not AGGREGATE workspace object(partition number) because it depends on unaggregated compressed partition number. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-37123: (XSCCOMP17) Can not AGGREGATE workspace object(partition number) because it depends on unaggregated compressed partition number.

Reason for the Error ORA-37123: (XSCCOMP17) Can not AGGREGATE workspace object(partition number) because it depends on unaggregated compressed partition number.

attempted to use a feature not supported by CC’s in the current AW format

How to fix the Error ORA-37123: (XSCCOMP17) Can not AGGREGATE workspace object(partition number) because it depends on unaggregated compressed partition number. ?

You can fix this error in Oracle by following the below steps

Remove the unsupported feature from the aggmap, or upgrade the AW