"The materialized view %1 cannot be changed to immediate because it has already been initialized"
| Item |
Description |
|
SQLCode
|
-1170L
|
|
Constant
|
IMMEDIATE_MV_REFRESH_NOT_ALLOWED
|
|
SQLState
|
42WC3
|
|
ODBC 2 State
|
42000
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
2847
|
|
Severity Code
|
14
|
|
Parameter 1
|
Name of the materialized view.
|
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.