"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.