SQL> alter system set undo_tablespace=undo2;
System altered.
SQL> update scott.emp set sal=sal+1;
14 rows updated.
SQL> select XIDUSN from v$transaction;
XIDUSN
----------
14
SQL> alter system set undo_tablespace=undo2;
System altered.
SQL> update scott.emp set sal=sal+1;
14 rows updated.
SQL> select XIDUSN from v$transaction;
XIDUSN
----------
14