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