"alter table dbo.mytable add partition (part89 VALUES (227))” fails with Error 2601:
Number (2601) Severity (16) State (6) Server (my ASE) Attempt to insert duplicate key row in object 'syspartitions' with unique index 'nc2syspartitions'
- dbo.mytable is a list partitioned table with no partition named "part89".
- The partition key is defined on a smallint column and 227 is valid value.
- There is also no partition with the partition key 227.
- The "alter table" command is executed via isql.
SAP Adaptive Server Enterprise (ASE) 16.0
syspartitions, mismatch, name, partitioned, local , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.