In this blog post, let’s learn about the error message “20255 An invalid partition management operation was specified for an index. Only ADD, DROP, and MOVE requests are supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20255 An invalid partition management operation was specified for an index. Only ADD, DROP, and MOVE requests are supported.
Reason for the Error
You attempted a partition management request other than ADD, DROP, or MOVE on an index. The REUSE request works only with range-partitioned requests.
Solution
None