SAP Knowledge Base Article - Preview

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

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.


Read more...

Environment

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

Product

SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6 ; Sybase PowerAMC 16.5

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.