Delete a rollback segment with undo_management set to AUTO?
Posted on 2007-04-03
I want to drop a large rollback segment in my UNDOTBS1 tablespace, but my database has the undo_management parameter set to AUTO. Is there any way to drop that one segment without changing that parameter?
To let you know why I ask the question, I was experimenting with ways to add large numbers of rows to a table. I tried creating 46,000,000 rows without doing a periodic commit, let it run for about 14 hours, and just aborted it. Now I have a rollback segment taking up 5 Gigs of harddrive space that is totally unnecessary - I've learned my lesson and won't be doing updates or inserts of that size without periodic commits.