[重慶思莊每日技術分享]-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