The materialized view %1 cannot be changed to immediate because it has already been initialized

Error constant	SQLE_IMMEDIATE_MV_REFRESH_NOT_ALLOWED
ODBC 2 State	42000
ODBC 3 State	ERROR
Parameter 1	Name of the materialized view.
Severity	14
SQLCODE	–1170
SQLSTATE	42WC3
Sybase error code	13343

Probable cause

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.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.