ALTER TABLE for adding an Oracle Subpartition

[robert_kratschmann]

Hi,

in PowerDesigner 16.5 SP05 PL05 there seems to be no way to add a subpartition in Oracle 12c with

ALTER TABLE DWHCO.TB0_COUNTERPARTY

modify PARTITION YYMM_9999

add subpartition CP_SP

values ('SP');

Adding the subpartition CP_SP into a PDM allways leads into a script of the form

alter table DWHCO.TB0_COUNTERPARTY rename to "tmp_TB0_COUNTERPARTY";

create table DWHCO.TB0_COUNTERPARTY (... SUBPARTITION CP_SP VALUES ('SP'), ...)

drop table DWHCO.tmp_TB0_COUNTERPARTY;

In "Apply Model Changes to Database" the radio button "Use alter statements when possible" exists for adding/dropping/... columns.

The switch seems to have no effect for adding a subpartition - is there another possibility to enforce an ALTER TABLE?

Many thanks

Robert

[former_member200945 · Accepted solution]

I'm afraid you'll not get alter statement.

For the purpose of data integrity protection, Powerdesigner code generation engine has

a few dozen of rules to decide whether or not a change in the model can lead to alter statement.

That's why it states "Use alter statements when possible"

[GeorgeMcGeachie · Accepted solution]

phillip.lam Sorry if you've answered this elsewhere, but where can we find at least a summary of the rules that PowerDesigner uses to decide when to produce (or not produce) Alter statements?