Resize, recreate undo tablespace, ORA-30013, ORA-03297

Resize, recreate undo tablespace.


rem Get rid of these errors.

ERROR at line 1:
ORA-30013: undo tablespace 'UNDOTBS1' is currently in use

ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value



Rem Resize, recreate undo tablespace.



create undo tablespace undotbs2 datafile

'D:\ORACLE\ORA9I\ORADATA\ORA9I\UNDOTBS02.DBF' SIZE 200M REUSE AUTOEXTEND ON;


Rem This tablespace as Undo Tablespace.



alter system set undo_tablespace = undotbs2;

drop tablespace undotbs1 including contents and datafiles;

Rem there is similar procedure to resize, recreate Temp tablespace.