create undo tablespace undotbs2 datafile ‘/u02/oradata/orcl/undotbs2.dbf’ size 1000m autoextend on maxsize 1000M;

alter system set undo_tablespace=undotbs2 scope=both;

create pfile=’/home/oracle/p.undo.ora’ from spfile;

drop tablespace undotbs1 including contents and datafiles;

create undo tablespace undotbs1 datafile ‘/u02/oradata/orcl/undotbs1.dbf’ size 1000m autoextend on maxsize 1000M;

alter system set undo_tablespace=undotbs1 scope=both;

create pfile=’/home/oracle/p.undo1.ora’ from spfile;

drop tablespace undotbs2 including contents and datafiles;