In this blog post, let’s learn about the error message “QL 1211812118 DDL operation operation-name is not supported on materialized view.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
QL 1211812118 DDL operation operation-name is not supported on materialized view.
Reason for the Error
You attempted to create an object on the materialized view as a dependent object.
Solution
Do not create objects, such as INDEX or TRIGGER, on a materialized view