oracle多租户（本地和共享的撤消表空间）

切换到共享撤消模式

这是本地撤消表空间
select property_name, property_value
from database_properties
where property_name = ‘LOCAL_UNDO_ENABLED’;

有撤消表空间
select con_id, tablespace_name
from cdb_tablespaces
where contents = ‘UNDO’;

查看数据文件
alter session set container = pdb2;
select file_name
from dba_data_files
where tablespace_name = ‘UNDOTBS1’;


shutdown immediate;
startup upgrade;
alter database local undo off;
shutdown immediate;
startup;

查看修改结果


原来的数据文件和表空间还在
alter session set container = pdb2;
select file_name
from dba_data_files
where tablespace_name = ‘UNDOTBS1’;


删除表空间
drop tablespace undotbs1;

切换到本地撤消模式

现在是共享撤消模式


shutdown immediate;
startup upgrade;
alter database local undo on;
shutdown immediate;
startup;

select property_name, property_value
from database_properties
where property_name = ‘LOCAL_UNDO_ENABLED’;


自动生成了PDB2的UNDO表空间
alter session set container = cdb$root;
select con_id, tablespace_name
from cdb_tablespaces
where tablespace_name LIKE ‘UNDO%’
order by con_id;