I know how to move (using rename) datafiles belonging to regular tablespaces. What I would like to know is if I am changing the location of datafiles belonging to the rollback tablespace how do I go about doing it? Is it similar as for system (where the db is in mount stage)?
It's better to do it just the way for System dbf. You can attempt to do this when the db is running, but if a rbs is active, you will not be able to take the ts offline and if successful, a user will get an error if a transaction is carried out when the ts is offline.