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

admin

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

1. [oracle@vm3 ~]$ export ORACLE_SID=orcl
   
2. [oracle@vm3 ~]$ dbca
   
3. [oracle@vm3 ~]$ sqlplus / as sysdba
   
4. SQL> select userenv('language') from dual;
   
5. 
   
6. USERENV('LANGUAGE')
   
7. ----------------------------------------------------
   
8. AMERICAN_AMERICA.AL32UTF8
   
9. 
   
10. SQL> !mkdir -p /app/oracle/db/oradata/ORCL/pdb1
    
11. 
    
12. SQL> alter session set container=cdb$root;
    
13. 
    
14. Session altered.
    
15. 
    
16. SQL> create pluggable database pdb1 admin user pdb1 identified by pdb1 create_file_dest='/app/oracle/db/oradata/ORCL/pdb1';
    
17. 
    
18. Pluggable database created.
    
19. 
    
20. SQL> show pdbs;
    
21. 
    
22.     CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    
23. ---------- ------------------------------ ---------- ----------
    
24.          2 PDB$SEED                       READ ONLY  NO
    
25.          3 PDB1                           MOUNTED
    
26. SQL> alter pluggable database pdb1 open;
    
27. 
    
28. Pluggable database altered.
    
29. 
    
30. SQL> select userenv('language') from dual;
    
31. 
    
32. USERENV('LANGUAGE')
    
33. ----------------------------------------------------
    
34. AMERICAN_AMERICA.AL32UTF8
    
35. 
    
36. SQL> alter pluggable database close immediate;
    
37. 
    
38. Pluggable database altered.
    
39. 
    
40. SQL> alter pluggable database open read write restricted;
    
41. 
    
42. Pluggable database altered.
    
43. 
    
44. SQL> alter session set container=pdb1;
    
45. 
    
46. Session altered.
    
47. 
    
48. SQL> alter database character set internal_use zhs16gbk;
    
49. 
    
50. Database altered.
    
51. 
    
52. SQL> alter pluggable database pdb1 close;
    
53. 
    
54. Pluggable database altered.
    
55. 
    
56. SQL> alter pluggable database pdb1 open;
    
57. 
    
58. Pluggable database altered.
    
59. 
    
60. SQL> alter session set container=pdb1;
    
61. 
    
62. Session altered.
    
63. 
    
64. SQL> select userenv('language') from dual;
    
65. 
    
66. USERENV('LANGUAGE')
    
67. ----------------------------------------------------
    
68. AMERICAN_AMERICA.ZHS16GBK
    
69. 
    
70. SQL>

复制代码