In this blog post, let’s learn about the error message “3424 NO PARTITION, MAX TABLE SIZE, or DISK POOL clauses are not supported for the materialized views.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3424 NO PARTITION, MAX TABLE SIZE, or DISK POOL clauses are not supported for the materialized views.
Reason for the Error
Either NO PARTITION, MAX TABLE SIZE, or DISK POOL clauses were supplied to the CREATE MATERIALIZED VIEW statement.
Solution
Remove the unsupported clause from the statement and retry
