Oracle Error ORA-33044: (XSAGDNGL21) AGGREGATE operator string requires a WEIGHTBY clause, but the ARGS clause in AGGMAP workspace object did not specify one.

Oracle Error Message

ORA-33044: (XSAGDNGL21) AGGREGATE operator string requires a WEIGHTBY clause, but the ARGS clause in AGGMAP workspace object did not specify one.

Reason for the Error

The user used an operator which needs weight values but not provided the weight values.

Solution

Provide weight values using a WEIGHTBY cluase.