重建UNDO表空间

shutdown immediate
startup
create TEMPORARY tablespace TEMP2 TEMPFILE 'D:ORADATASMSDBTEMP02.DBF' size 5M reuse autoextend on next 10M;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP2";
DROP TABLESPACE TEMP;
host del D:ORADATASMSDBTEMP01.DBF;

create TEMPORARY tablespace TEMP TEMPFILE 'D:ORADATASMSDBTEMP01.DBF' size 512M reuse autoextend on next 10M;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP";
DROP TABLESPACE TEMP2;
host del D:ORADATASMSDBTEMP02.DBF;