--確認字pdb的符集 alter session set container=PDBTEST; select userenv('language') from dual;
rac實例修改時和單實例有點不同，需要先停提所有其它instance，修改后再打開。
--修改字符集 alter pluggable database PDBTEST close immediate instances=all; alter pluggable database PDBTEST open read write restricted; -- in container PDBTEST alter session set container=PDBTEST; select userenv('language') from dual; alter database character set internal_use zhs16gbk; alter pluggable database PDBTEST close immediate;
--啟動pdb確認 alter pluggable database PDBTEST open instances=all; alter session set container=PDBTEST; select userenv('language') from dual; <<<<<<<<<<此時字符集已經修改
alter pluggable database all save state; --啟動一下服務 srvctl start service -db ora12c -service tims
