[重庆思庄每日技术分享]-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