In this blog post, let’s learn about the error message “20169 Only the last partition of a hash-partitioned table or index can be dropped.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20169 Only the last partition of a hash-partitioned table or index can be dropped.
Reason for the Error
The partition you specified in the DROP request is not the last partition.
Solution
Use the LAST PARTITION syntax and resubmit
