PDB修改字符集

一、查看字符集

1.1 CDB字符集

select userenv('language') from dual;
AMERICAN_AMERICA.AL32UTF8

1.2 PDB字符集

select userenv('language') from dual;
AMERICAN_AMERICA.AL32UTF8

二、修改字符集

2.1、重启至限制模式

alter pluggable database orcl close immediate instances=all;
alter pluggable database orcl open read write restricted;

2.2、进入PDB修改

alter session set container=orcl;
select userenv('language') from dual;
alter database character set internal_use zhs16gbk;

2.3、重启确认

alter pluggable database orcl close immediate;
alter pluggable database orcl open instances=all;
alter session set container=orcl;
select userenv('language') from dual;
alter pluggable database orcl save state instances=all;

三、测试库测试情况

SQL> create pluggable database  emtest from template;

Pluggable database created.

SQL> alter pluggable database emtest open;

Pluggable database altered.

SQL> alter session set container=emtest;

Session altered.

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

SQL> alter pluggable database emtest close immediate instances=all;

Pluggable database altered.

SQL> alter pluggable database emtest open read write restricted;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        36 EMTEST                         READ WRITE YES
		
SQL> alter session set container=emtest;

Session altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        36 EMTEST                         READ WRITE YES
SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

SQL> alter database character set internal_use zhs16gbk;

Database altered.

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

SQL> alter pluggable database emtest close immediate;

Pluggable database altered.

SQL> alter pluggable database emtest open;

Pluggable database altered.

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

SQL> alter pluggable database emtest save state instances=all;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        36 EMTEST                         READ WRITE NO