So we recently upgraded to 19c from 12c and we implemented partitions in our huge problematic tables, however my question is what should we do now:
- Delete from 01.01.2022 to 10.10.2022
- drop partition from 01.01.2022 to 10.10.2022
I read that partitions work seemlessly so you should be dropping partitions but instead just delete data from table the old fashioned way, but I couldn't find enough information to support each.