HPE NonStop SQL/MX Error – 20169 Only the last partition of a hash-partitioned table or index can be dropped.

Data 18 Views 1 Min Read

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

Tags: