and what about creating additional rollback segments and dropping the older ones.
Thanks
Anurag
Printable View
and what about creating additional rollback segments and dropping the older ones.
Thanks
Anurag
Again, I'd prefer to drop and create rollback segments one by one
in order to use the same names for new rollback segments,
otherwise don't forget to correct "rollback segments" line in init.ora if exists.
Inosov right, one more reason:
if application has "set transaction use rollback segment " then rollback segment names has to be fixed in database. Some applications are smart enough not to hard code those values but to have init params, but those has to be changed anyway.
In general, DBA's should understand that application may rely on a lot of things in a database (e.g. index names)