oracle19c运营模式,Oracle19c基本操作

0、查看db

show con_name

show pdbs

1、cdb切换至pdb

alter session set container=pdb;

2、pdb切换至cdb

alter session set container=cdb$root;

3、pdb更改字符集(cdb的字符集必须为al32utf8)

alter system enable restricted session; (恢复操作为alter system disable...)

alter database character set internal_use zhs16gbk;

注：使用低版本的client在不同字符集的pdb之间切换会报错：ora-24964

4、实例启动后自动打开所有pdb

CREATE OR REPLACE TRIGGER open_pdbs AFTER STARTUP ON DATABASE

BEGIN

EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';

END open_pdbs;

5、pdb克隆

create pluggable database pdb2 from pdb1 file_name_convert=('pdb1path','pdb2path');