Skip to Content
0
Sep 07, 2016 at 01:37 PM

ALTER TABLE for adding an Oracle Subpartition

222 Views

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