1-查询undo对应的表空间

select * from dba_tablespaces;

查询表空间结果

2-创建新的表空间

tablespace
create undo tablespace undotBS3
datafile'D:\ORACLE\PRODUCT\10.2.0\ORADATA\CICBOM\TEMP2022042001.DBF'
size 100m;

3-设置undo的表空间为新的表空间

alter system set undo_tablespace=undotBS3;

4- 删除旧的表空间

drop tablespace undotbs2 including contents;

5-删除物理文件

D:\ORACLE\PRODUCT\10.2.0\ORADATA\CICBOM\TEMP01.DBF