1.创建一个新的undo表空间作为备用
create BIGFILE undo tablespace UNDOTBS2 datafile ‘路径/undotbs02.dbf’ SIZE 1G
AUTOEXTEND ON NEXT 1G
MAXSIZE UNLIMITED
ONLINE
RETENTION GUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;
2.修改undo表空间 alter system set undo_tablespace=UNDOTBS2;
3.删除之前的undo表空间 drop tablespace UNDOTBS1 including contents and datafiles;
4.在创建一个名称和之前一样的undo表空间
create BIGFILE undo tablespace UNDOTBS1 datafile ‘路径\undotbs01.dbf’ SIZE 1G
AUTOEXTEND ON NEXT 1G
MAXSIZE UNLIMITED
ONLINE
RETENTION GUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;
5.修改undo表空间 alter system set undo_tablespace=UNDOTBS1;
6.删除创建的临时表空间 drop tablespace UNDOTBS2 including contents and datafiles;
注意:
1.如果删除了,但是空间没有释放,需要重启一下orcale服务