Hi,
in 10g, all undo segments are offline :
SQL> select segment_name, tablespace_name,status
2 from dba_rollback_segs where tablespace_name like '%UNDO%';
SEGMENT_NAME TABLESPACE_NAME STATUS
------------------------------ ------------------------------ --------------
_SYSSMU1$ UNDOTBS1 OFFLINE
_SYSSMU2$ UNDOTBS1 OFFLINE
_SYSSMU3$ UNDOTBS1 OFFLINE
_SYSSMU4$ UNDOTBS1 OFFLINE
How tu put them ONLINE ?
Thank you.