Re: undo tablespace keeps growing, why can't I reclaim space?

Hans I tried but couldn't follow all of your explanation.

If you have more than one commit, each commit causes the beginning of a new transaction.

Each new transaction can go to a different undo segment.

Do you have the same volume of data in test and production? Do you have the same indexes in place?

It seems unlikely that something that takes 2-3 gig in test will take 40 gig in production unless there are big differences in your environment that don't seeem clear to me yet. Received on Mon Aug 15 2005 - 08:46:50 CDT