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'