"TRUNCATE TABLE not allowed: initialized immediate materialized view %1 depends on %2"
| Item |
Description |
|
SQLCode
|
-1193L
|
|
Constant
|
TRUNCATE_TABLE_WITH_IMV
|
|
SQLState
|
55W30
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
2870
|
|
Severity Code
|
16
|
|
Parameter 1
|
Name of the dependent initialized immediate materialized view.
|
|
Parameter 2
|
Name of the table on which TRUNCATE TABLE was performed.
|
Probable cause
TRUNCATE TABLE is not permitted on any table that has dependent initialized immediate materialized views.