{16 追加}UNDOモード変更

https://docs.oracle.com/cd/F19136_01/multi/administering-a-cdb-with-sql-plus.html#GUID-24EA5811-94F0-4EEC-864F-23AEF48F2D51

SELECT PROPERTY_NAME, PROPERTY_VALUE
FROM   DATABASE_PROPERTIES
WHERE  PROPERTY_NAME = 'LOCAL_UNDO_ENABLED';

 

  ローカルUNDOモード -> 共有UNDOモード

select * from cdb_data_files where TABLESPACE_NAME like 'UNDO%';

shutdown immediate
startup upgrade

alter database local undo off;

shutdown immediate
startup

select * from cdb_data_files where TABLESPACE_NAME like 'UNDO%';

※PDB起動後に生成されるUNDOは削除する
drop tablespace UNDO including contents and datafiles;

 

  共有UNDOモード -> ローカルUNDOモード

select * from cdb_data_files where TABLESPACE_NAME like 'UNDO%';

shutdown immediate
startup upgrade

alter database local undo on;

shutdown immediate
startup

select * from cdb_data_files where TABLESPACE_NAME like 'UNDO%';