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');