How Drop the only subpartition of a partition

Question

While I am deleting subpartitions, one of the partition contains only one subpartition I got an error.

Error: ORA-14629 cannot drop the only subpartition of a partition

Can anyone know how to drop single subpartition of a partition

score 0 · Accepted Answer · answered Jan 12 '22 at 12:58

0

If the partition contains only one subpartition, you can drop the partition instead.

R

answered Jan 12 '22 at 12:58

Rownum Highart

New subpartitions will be added to the partition, so old subpartitions have to be deleted – Logan Jan 12 '22 at 15:03
If this is an issue of replacing all the subpartitions, you can use this algorithm: 1. add a temporary subpartition X, 2. remove all the old subpartitions, 3. add the new subpartitions, 4. remove the temporary subpartition X. – Rownum Highart Jan 12 '22 at 15:33

1 Answers1