Oracle Error ORA-40122: invalid data type for row weights column string.

Oracle Error Message

ORA-40122: invalid data type for row weights column string.

Reason for the Error

Row weights column was not assigned one of the allowed data types.

Solution

Choose a row weight column of type NUMBER or FLOAT.