1 CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE ‘/vol1/oracle/oradata/oracle1/undotbs02.dbf’ SIZE 50 M AUTOEXTEND OFF ; 2 ALTER SYSTEM SET undo_tablespace = UNDOTBS2 ; 3 DROP TABLESPACE undotbs1 INCLUDING CONTENTS AND DATAFILES ; 4 CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ‘/vol1/oracle/oradata/oracle1/undotbs01.dbf’ SIZE 500 M AUTOEXTEND ON NEXT 5 M ; 5 ALTER SYSTEM SET undo_tablespace = UNDOTBS1 ; 6 DROP TABLESPACE undotbs2 INCLUDING CONTENTS AND DATAFILES ;