-
as a practice dbas may create a separate rollback segment after the database is created to handle the jobs of creating tablespaces, rollback segments and running the scripts. after all these jobs are run that rollback segment is taken off line for the simple reason that the second rbs is created in system tablespace. if the name of that 2nd rbs is 'systemrbs' that is ok. but the rbs created by oracle for the maintenance of meta data tables at the time of creating the database can not be taken offline.
-
Sorry about not completely covering all the bases with using the system rollback segment for transactions. Yes, of course there was a way, as proved above. But if you follow Oracle's rules on the system tablespace you should never run into this problem. That rule being never to create objects in the system tablespace.