In this blog post, you’ll learn more about the Sybase Error Invalid text index type for the materialized view and the reason for receiving this error
Sybase SQL Error Message
Invalid text index type for the materialized view
Reason for this Error
Text index with the specified refresh type cannot be created on the materialized view. Only IMMEDIATE REFRESH text indexes are allowed on materialized views.