5690 LOBs are not allowed to be hashed.
Explanation:
LOBs are not allowed to be hashed. Hashing is required for UNION, INTERSECT, MINUS, and DISTINCT queries containing LOB columns or for ORDER BY's on LOB columns.
Generated By:
OPT modules.
For Whom:
End User.
Remedy:
Remove the LOB column and resubmit.