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)?
SYSTEM, you definitely have to be in MOUNT mode. RBS, I'm not sure, but as long as you are in MOUNT mode, I'd do it then...
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.