In this blog post, you’ll learn more about the Sybase Error The materialized view %1 cannot be changed to immediate because it has already been initialized and the reason for receiving this error
Sybase SQL Error Message
The materialized view %1 cannot be changed to immediate because it has already been initialized
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view which is already in an initialized state. Truncate the view before changing the refresh type.