In this blog post, you’ll learn more about the Sybase Error Statement not allowed on text index for a materialized view and the reason for receiving this error
Sybase SQL Error Message
Statement not allowed on text index for a materialized view
Reason for this Error
You cannot use REFRESH TEXT INDEX or TRUNCATE TEXT INDEX on a text index that is created for a materialized view. You cannot alter the text index to use a different refresh type.