Problem

Oracle db running out of space.

Solution

Make sure the old partitions are dropped. Documentation for alternate DROP PARTITION, https://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin002.htm#i1007479,

See section "Dropping Interval Partitions"

Additionally you can list a tables partitions with the following command select * from ALL_PART_TABLES where table_name = 'target_table_name'

If you have difficulty or questions please contact our Support for assistance.