First, deleting 600 rows of data from a table will not generate that much undo, so if you are that tight on disk,
you would have many problems other than just deleting data from a table. It is time to procure more disk.
Second, the only method that will remove rows from a table and not generate undo is to use the TRUNCATE TABLE command. But that will remove all rows from the table. You cannot delete the first 600 rows from a table and not generate any undo.
Third, there is no such thing as "the first xxx rows" of data in a table. By definition, rows in a table are unordered. So there is no first or last row of data. This is fundamental to the basics of relational database theory.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.