2178704 - Oracle table dropped/recreated when maintaining partitions - SAP PD

• 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."

• SAP PowerDesigner (PD) 16.5
• SAP PowerDesigner (PD) 16.6
• Oracle DBMS

Oracle, table, partitioning, partition, alter, drop, add, delete, new, modify, pdm , KBA , oracle , powerdesigner , partitions , BC-SYB-PD , PowerDesigner , Problem