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