Toad World® Forums

12.9.0.46 Alter table - add subpartition

During my work I tried to add a subpartition to an already partitioned table, but the operation fails.

I saved the generated script that was:

ALTER TABLE MEF.D_PROTOCOLLI

MODIFY PARTITION CORRENTE

ADD SUBPARTITION CORRENTE_AOO_058 VALUES (4000,4001,4002)

NO INMEMORY TABLESPACE TS_MEF_DATI;

an older version of toad generate another script for the same operation:

ALTER TABLE MEF.D_PROTOCOLLI

MODIFY PARTITION CORRENTE

ADD SUBPARTITION CORRENTE_AOO_058 VALUES (4000,4001,4002)

TABLESPACE TS_MEF_DATI;

and this work, instead.

This happens in the same environment (same machine) and same database.

I’m using Instant Client 11.2.0.4

What is the Oracle server version?

Ignore my prior reply. Fixed for next beta.