Oracle Error ORA-37522: (HASHSCAN01) You must specify the name of an existing TEXT or NTEXT dimension.

Oracle Error Message

ORA-37522: (HASHSCAN01) You must specify the name of an existing TEXT or NTEXT dimension.

Reason for the Error

the _HASHSCAN program was invoked with an invalid argument

Solution

Provide a text expression yielding the name of an existing TEXT dimension