"The materialized view cannot be changed to immediate because it does not have a unique index on non-aggregate non-nullable columns"
Item |
Description |
SQLCode
|
-1218L
|
Constant
|
UPDATABLE_MATVIEW_NON_AGGR_INDEX
|
SQLState
|
42WC7
|
ODBC 2 State
|
42000
|
ODBC 3 State
|
ERROR
|
Sybase Error Code
|
2896
|
Severity Code
|
16
|
Probable cause
You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-aggregate non-nullable columns. Create a unique index on the materialized view before changing the refresh type.