SQL> col name for a30;
SQL> col value for a40;
SQL> select name,value from v$parameter where name like '%undo%';
NAME VALUE
------------------------------ ----------------------------------------
undo_management AUTO
undo_tablespace UNDOTBS1
undo_retention 9000
SQL> select tablespace_name ,status,contents from dba_tablespaces where contents='UNDO';
TABLESPACE_NAME STATUS CONTENTS
------------------------------ ------------------ ------------------
UNDOTBS1 ONLINE UNDO
TEST_UNDO ONLINE UNDO
SQL> alter system set UNDO_TABLESPACE=test_undo;
System altered.
SQL> select name,value from v$parameter where name like '%undo%';
NAME VALUE
------------------------------ ----------------------------------------
undo_management AUTO
undo_tablespace TEST_UNDO
undo_retention 9000
SQL> alter system set UNDO_TABLESPACE=undotbs1;
System altered.
SQL> select name,value from v$parameter where name like '%undo%';
NAME VALUE
------------------------------ ----------------------------------------
undo_management AUTO
undo_tablespace UNDOTBS1
undo_retention 9000