Can You Use Multiple Undo Tablespaces?
Answer: Undo tablespaces are relevant only in the SMU mode. You can create multiple undo tablespaces in Oracle9i by using the CREATE UNDO TABLESPACE command. However, at any given time only one undo tablespace can be active in the database. The value of the parameter UNDO_TABLESPACE determines the undo tablespace that's active.