The materialized view %1 cannot be changed to immediate because it does not have a unique index on non-nullable columns

Error constant	SQLE_IMMEDIATE_MV_NO_UNIQUE_INDEX
ODBC 2 State	42000
ODBC 3 State	ERROR
Parameter 1	Name of the materialized view.
Severity	14
SQLCODE	–1233
SQLSTATE	42WCA
Sybase error code	13284

Probable cause

You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-nullable columns. Create a unique index on the materialized view before changing the refresh type.

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