Create a new fixed size UNDO tablespace & Switch UNDO tablespace

Version:

Oracle 11.2.0.4

OS:

Windows

SQLs to create a new fixed size undo tablespace and switch to the new undo tablespace:

create undo tablespace UNDOTBS2 datafile 'D:\ORACLE\ORADATA\DB1\DATAFILE\UNDOTBS2_01.DBF' size 8g;

alter system set undo_tablespace = UNDOTBS2;

Oracle documentation on Managing Undo Tablespaces:

https://docs.oracle.com/cd/E11882_01/server.112/e25494/undo.htm#ADMIN11470