One of my rollback segment status in dba_rollback_segs is
'needs recovery'. My database is not in archive mode.

alter rollback segment rb23 offline;
alter rollback segment rb23 online;
drop rollback segment rb23;
all above written statement does not work

Kindly tell me how can i solve this problem

from Anuj Pathak