UNDO TABLESPACE CORRUPTED

SQL> SHUTDOWN IMMEDIATE
ORACLE instance shut down.

change the undo_tablespce settings in pfile undo_tablespace='SYSTEM' AND undo_management='MANUAL'

SQL> STARTUP PFILE='D:\oracle\product\10.2.0\db_1\database\INITorcl.ora';
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1292036 bytes
Variable Size             171968764 bytes
Database Buffers          432013312 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.

SQL> drop tablespace undotbs1 including contents and datafiles;

Tablespace dropped.

SQL>  create undo tablespace undotbs2 datafile 'C:\oracle\product\10.2.0\ORADATA
\ORCL\UNDOTBS02.dbf' size 100m AUTOEXTEND ON NEXT 10M;

Tablespace created.

SQL> SHUTDOWN IMMEDIATE

change the undo_tablespce settings in pfile undo_tablespace='UNDOTBS2' AND undo_management='AUTO'

ORACLE instance shut down.
SQL> STARTUP PFILE='D:\oracle\product\10.2.0\db_1\database\INITorcl.ora';
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1292036 bytes
Variable Size             171968764 bytes
Database Buffers          432013312 bytes
Redo Buffers                7094272 bytes
Database mounted.
Database opened.
SQL>