In this blog post, let’s learn about the error message “1117 Dropping the only partition of an object is not allowed. At least two partitions must exist to perform the drop.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1117 Dropping the only partition of an object is not allowed. At least two partitions must exist to perform the drop.
Reason for the Error
You attempted to drop the only partition of the object.
Solution
None
