In this blog post, let’s learn about the error message “1248 Partition name partition-name has already been used. Each partition in an object should have a unique name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1248 Partition name partition-name has already been used. Each partition in an object should have a unique name.
Reason for the Error
Partition names are required to be unique within the set of partitions of an object.
Solution
Choose a name that is not the same as any other partition name in this object and reissue the CREATE statement
