oracle 修改字符集_pdb修改成与cdb不一样得字符集

点上边蓝字关注我们

cdb得字符集是utf8,新建默认字符集pdb1,再修改pdb1字符集为16gbk，印证一下19c上cdb支持不同字符集pdb得特性。

[oracle@vm3 ~]$ export ORACLE_SID=orcl [oracle@vm3 ~]$ dbca [oracle@vm3 ~]$ sqlplus / as sysdba SQL> select userenv('language') from dual; USERENV('LANGUAGE') ---------------------------------------------------- AMERICAN_AMERICA.AL32UTF8 SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO SQL> alter session set container=pdb$seed; Session altered. SQL> select name from v$datafile; NAME --------------------------------------------------------------------------- /app/oracle/db/oradata/ORCL/pdbseed/system01.dbf SQL> !mkdir -p /app/oracle/db/oradata/ORCL/pdb1 SQL> alter session set container=cdb$root; Session altered. SQL> create pluggable database pdb1 admin user pdb1 identified by pdb1 create_file_dest='/app/oracle/db/oradata/ORCL/pdb1'; Pluggable database created. SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB1                           MOUNTED SQL> alter pluggable database pdb1 open; Pluggable database altered. SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB1                           READ WRITE NO SQL> select userenv('language') from dual; USERENV('LANGUAGE') ---------------------------------------------------- AMERICAN_AMERICA.AL32UTF8 SQL> alter pluggable database close immediate; Pluggable database altered. SQL> alter pluggable database open read write restricted; Pluggable database altered. SQL> alter session set container=pdb1; Session altered. SQL> select userenv('language') from dual; USERENV('LANGUAGE') ---------------------------------------------------- AMERICAN_AMERICA.AL32UTF8 SQL> alter database character set internal_use zhs16gbk; Database altered. SQL> alter pluggable database pdb1 close; Pluggable database altered. SQL> alter pluggable database pdb1 open; Pluggable database altered. SQL> alter session set container=pdb1; Session altered. SQL> select userenv('language') from dual; USERENV('LANGUAGE') ---------------------------------------------------- AMERICAN_AMERICA.ZHS16GBK SQL>