I am quite new to this oracle buisiness; just wondering does the undo table space keep getting bigger and bigger; how can i free the space it uses and or limit the size (with-out getting errors about running out of undo space)?
I know how to do that; it just when i do a delete of six - eight million rows it gets kinda full. It also crashed giving an error (here). I wish to try to avoid this but have limits with disc space. How can i limit the amount of stuff oracle attempts to save in undo (i.e. so that it uses say 1000mb for undo and when it gets to 1000mb it starts to overrite the old stuff.)
You can set a parameter, I think it's called undo_retention or something.
This is the number of seconds that undo information has to be kept. Try to make this value lower, so it will release old info sooner.
See the link I mentioned above for the exact name and description of the parameter.