重庆思庄Oracle、Redhat认证学习论坛
标题:
ORACLE19C UNDO共享模式转换为本地模式
[打印本页]
作者:
郑全
时间:
2021-10-29 18:03
标题:
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
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)
Powered by Discuz! X3.2