undo表空间迁移

1. 创建新的临时表空间
   SQL> create undo tablespace undotbs2 datafile ‘/storage/ORA_DATA/UNDOTBS2.dbf’ size 100m reuse autoextend on next 200m ;

2. 切换UNDO表空间为新的UNDO表空间 ， 动态更改spfile配置文件；
   SQL> alter system set undo_tablespace=undotbs2 scope=both;

3. 等待原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

4. 删除原有的UNDO表空间
   SQL>drop tablespace undotbs1 including contents and datafiles;

5. open pluggable database
   SQL> alter pluggable database pdbsjzk open;