-20381 ALTER INDEX WITH REGENERATE OPTION IS NOT VALID FOR index-name

index-name

Explanation
 The
REGENERATE option is allowed only if the index is an expression-based
index.

System action
 The statement cannot be processed.

Programmer response
 Change the statement so that it refers
to an index that can be regenerated.

SQLSTATE
 530A5