Delete large amount of data from a single table
I have 300 million row oracle table. I need to delete 200 million rows from the table. I'm concerned the DML DELETE will create huge amount of UNDO and REDO. I want to break the DELETE into a few batches, for example, delete a batch of 100K rows at a time. Right now I'm dumping to-be-deleted rows into CSV file. How do I use the CSV file as an external table to select the batch of 100K rows so to delete from the 300 million row table? The Oracle Database version I'm using is 19c.