Oracle数据库管理-cdb，PDB配置undo和temp，local undo

1 CBD配置undo和temp

local undo和shared undo，从12.2开始可以使用local undo方式。

create undo tablespace undocdb1 datafile '+dgdata4' size 1G autoextend off;

create undo tablespace undocdb2 datafile '+dgdata4' size 1G autoextend off;

alter system set undo_tablespace='undocdb1' sid='orcl1';

alter system set undo_tablespace='undocdb2' sid='orcl2';

 

create temporary tablespace tempcdb datafile '+dgdata4' size 1G autoextend off;

alter database default temporary tablespace tempcdb；

 

2 为pdb创建undo和temp表空间。

alter session set container=orcl

create temporary tablespace tempdnms datafile '+dgdata4' size 1G autoextend off;

alter database default temporary tablespace tempdnms；

create undo tablespace undoorcl1 datafile '+dgdata4' size 1G autoextend off;

create undo tablespace undoorcl2 datafile '+dgdata4' size 1G autoextend off;

alter system set undo_tablespace='undoorcl1' sid='orcl1';

alter system set undo_tablespace='undoorcl2' sid='orcl2';

alter pluggable database orcl save state;

3 总结

各个pdb单独使用自己的system、sysaux、temp和undo。