oracle undo文件太大处理流程

sqlplus /nolog;
conn / as sysdba;

创建一个新的表空间UNDOTBS3:
Create UNDO TABLESPACE UNDOTBS3 DATAFILE '/home/oracle/oradata/yqdz/UNDOTBS03.DBF' SIZE 100M REUSE AUTOEXTEND ON;

切换当前undo表空间为UNDOTBS3：
alter system set undo_tablespace=UNDOTBS3;

释放原表空间：undotbs1
drop tablespace undotbs1 including contents;

查看新建好的表空间
select TABLESPACE_NAME from dba_tablespaces;

限制表空间
Alter DATABASE DATAFILE '/home/oracle/oradata/yqdz/UNDOTBS03.DBF' AUTOEXTEND ON MAXSIZE 300M;

删除旧的表空间文件
完成后删除:/home/oracle/oradata/yqdz/UNDOTBS01.DBF。