Change (default) TEMP and UNDO tablespace to bigfile tablespaces

Oracle: Change (default) TEMP and UNDO tablespace to bigfile tablespaces

That’s how to change the Oracle Datbase’s TEMP and UNDO tablespaces to bigfile (as possible in 10g and above).

TEMP tablespace to bigfile tablespace

create bigfile temporary tablespace TEMP1 tempfile \
     size 10G autoextend on next 1G maxsize 20G;

UNDO tablespace to bigfile tablespace

create bigfile undo tablespace UNDO1 datafile \
     size 10G autoextend on next 1G maxsize 20G;

alter system set undo_tablespace=UNDO1 scope=both sid='*';

alter database default temporary tablespace TEMP1;

drop tablespace UNDOTBS1;

drop tablespace TEMP;

 Follow steps carefully before do anything or playing with UNDO tablespace and Temp tablespace.