My point here is that, depending on your level of expertise, you probably know that, for example in a scenario you are keeping only 30% of the original data, you can CTAS just the portion of data you are keeping, drop the former table and rename it back to its original name. This way is much better and faster than a delete statement. I will not demonstrate that here as you can easily find articles on the web about that. If you do not know what I am talking about please read this one: Deleting many rows from a big table. Another option is dropping partitions if your table is partitioned, but partitioning requires Enterprise Edition and extra licensing. I am presenting here an operation that can be executed in any Oracle Database Enterprise Edition version 12.2 or above without the need of any extra license. Maybe by removing the "online" clause from the statement you can also run this in Standard Edition, but please check the licensing guide first and test.