First, deleting 600 rows of data from a table will not generate that much undo, so if you are that tight on disk,...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.