Originally posted by nealh
We had a consultant to review our database, who came up with some mostly stupid suggestions. One of them was to take the system rollback segment offline, which I didn't think that this was possible. When I try I get:

"ORA-01597: cannot alter system rollback segment online or offline"

Before I demand the money back, can anyone confirm whether this is the case or not ?
If he knows some magic trick about how to take the SYSTEM RBS offline, could he share it with us :-))

Where from did you find that consultant!