I am a little puzzled. I need to resize my rollbacks. I was thinking
of creating a new table space with the new rollback sizes, How do
you take the old rollbacks off line 1) while users are still on the system
and might be using them ? 2) My init.ora states what the rollback names
are

I thought at first, I could create the new tablespace and segments, and then
put them on line, by doing this, then Oracle knows about the table space
by the alter database command. so ideally Oracle now has 2 table spaces
RBS and BIG_RBS and the associated rollbacks, would you just start taking
off the rollbacks in RBS until they were all off line, and then take the
tablespace
off line ? leaving only the new BIG_RBS ?

I thought I read, by taking a rollback segment off line, while users were
still
connected to it, that you killed that process is this true ? How could you
prevent this ? This is a production system and when I show transactions
they change constantly as to what rollback is being used.

Thanks for the clarification.
John DeUnger.

Oracle LazyDBA home page