ORA-14758: Last partition in the range section cannot be dropped

Hello.

My app team reported the error

ORA-14758: Last partition in the range section cannot be dropped

when trying to drop old partitions from the tables that were initially created as range partitions, but later converted to interval. I have done some research on this issue (as I have never run into it before) and it looks like I have two options

- alter the code of the drop partition procedure to only drop the oldest partition with the name starting with SYS_P

- create a truncate partition procedure to truncate old range partitions (with the names not starting with SYS_P)