UNDOTBS01.DBF过大

sqlplus / as sysdba登录系统

PDB模式的话先切换Session

alter session set container = ora19cpdb;

确认一下undo的表空间名

show parameter undo;

 

创建新的undo表空间

create undo tablespace  undotbs03 datafile '/opt/oradata/undotbs03.dbf' size 100m autoextend on next 100m;

将undo指向新的表空间

alter system set undo_tablespace=undotbs03;

 删除原有表空间

drop tablespace undotbs02 including contents and datafiles;