Symptom
-
Table is dropped then recreated when the table partition is altered (e.g., creating a new partition or deleting an existing one) instead of generating the alter table partitioning_clause syntax.
-
For example, SAP PowerDesigner should generate:
alter table tablename
add partition;
to add a new partition and
alter table tablename
drop partition;
to drop a table partition.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP PowerDesigner (PD) 16.5
- SAP PowerDesigner (PD) 16.6
- Oracle DBMS
Product
Keywords
Oracle, table, partitioning, partition, alter, drop, add, delete, new, modify, pdm , KBA , oracle , powerdesigner , partitions , BC-SYB-PD , PowerDesigner , Problem
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.