In this blog post, let’s learn about the error message “12009 Object object-name cannot be dropped because it is being used by materialized view materialized-view-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
12009 Object object-name cannot be dropped because it is being used by materialized view materialized-view-name.
Reason for the Error
You issued a DROP statement against an object which has a dependent materialized view on it.
Solution
Drop the dependent materialized view and resubmit the statement or use the CASCADE option with the DROP statement
