sqldatabasedatabase-partitioningsql-dropsubpartition

How Drop the only subpartition of a partition

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

Solution

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

    R