Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center