-
创建新的临时表空间
SQL> create undo tablespace undotbs2 datafile ‘/storage/ORA_DATA/UNDOTBS2.dbf’ size 100m reuse autoextend on next 200m ; -
切换UNDO表空间为新的UNDO表空间 , 动态更改spfile配置文件;
SQL> alter system set undo_tablespace=undotbs2 scope=both; -
等待原UNDO表空间所有UNDO SEGMENT OFFLINE;
SQL>select usn,xacts,status,rssize/1024/1024,hwmsize/1024/1024, shrinks from v$rollstat order by rssize;
SQL> select t.segment_name,t.tablespace_name,t.segment_id,t.status from dba_rollback_segs t;
4
sql>shutdown immediate
sql> startup -
删除原有的UNDO表空间
SQL>drop tablespace undotbs1 including contents and datafiles; -
open pluggable database
SQL> alter pluggable database pdbsjzk open;
undo表空间迁移
最新推荐文章于 2024-03-11 07:00:00 发布