Will the "extra" ones ever go away or will they just stay offline. I have no idea when they were created. I just noticed them Friday after doing a test recovery of a single tablespace. >>> David Sharples <davidsharples@xxxxxxxxx> 6/21/05 2:34:31 PM >>> correct On 6/21/05, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote: > Two identical databases. > > Why does the second have more offline undo segments. Does Oracle > automatically create them if needed and when no longer needed offline it?? > -- //www.freelists.org/webpage/oracle-l