Troubleshooting
Drop Old Oracle DB Partitions
Problem
Oracle Database 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'