ORACLE19C UNDO共享模式转换为本地模式

郑全

SQL> select property_name, property_value from database_properties where property_name='LOCAL_UNDO_ENABLED';

no rows selected

SQL> shutdown immediate;
SQL> startup upgrade;

SQL> show con_name   >确认是 cdb，如果不是 cdb,则 alter session set container=cdb$root;

SQL> alter database local undo on;

SQL> shutdown immediate;
SQL> startup;
SQL>show pdbs
SQL>alter session set container=pdb1;

SQL>select name from v$datafile where name like '%undo%';
转换为本地模式，会自动给每个PDB创建UNDO TABLESPACE