Symptom
Error 325 when using ALTER TABLE to split a partition
Example:
alter table xxx_xxx_xxx_xxx partition pM20140201 into (
pD20160102 VALUES <(><<)>= ("D", "01/02/2016"),
pM20140201 VALUES <(><<)>= ("M", "02/01/2014")
)
Number (326) Severity (16) State (1) Server (XXXXXXX) ALTER TABLE 'xxx_xxx_xxx_xxx_info' failed. The table is 0-way partitioned, and a 1-way parallel plan was generated due to lack of parallel resources. Increase the value of 'max parallel degree' and 'number of worker processes' to at least 0, and try again.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
- Compatibility mode is on
Product
Keywords
326, error, message, msg, PARTITION, ALTER TABLE, SPLIT, compatibility mode , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.