Q

Deleting rows without space for undo generation data

If I want to delete the first 600 rows from one table and there is no disk space for undo generation data, what should I do?

This question was asked in an interview: If I want to delete the first 600 rows from one table and there is no disk space for undo generation data, what should I do? What is the way to sort out this problem?
If I were asked this question, I'd bring up three points.

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.

This was last published in July 2006

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close