In this blog post, let’s learn about the error message “1121 Partitions cannot be added or dropped on table table-name. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1121 Partitions cannot be added or dropped on table table-name. These partition operations are not allowed on tables whose clustering key consists only of the SYSKEY.
Reason for the Error
You attempted to do an invalid ADD, DROP, or MODIFY of a partition.
Solution
None
