How Drop the only subpartition of a partition-CodePudding

Home > Back-end > How Drop the only subpartition of a partition

How Drop the only subpartition of a partition

Time：01-13

While I am deleting subpartitions, one of the partition contains only one subpartition I got an error of ORA-14629 cannot drop the only subpartition of a partition

Can anyone know how to drop single subpartition of a partition

CodePudding user response：

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

Page link：https//www.codepudding.com/Backend/260789.html

Prev:Add join to display items based on key

Next:Oracle Regexp range doesn't work properly

Tags：

Links：
CodePudding