oracle修改字元編碼

標籤：lan   margin   技術   enable   ext   oracle   har   localhost   base   

 ALTER DATABASE character set INTERNAL_USE ZHS16GBK; 

 ALTER DATABASE CHARACTER SET ZHS16GBK; 

oracle修改字元編碼    1

1    開啟命令視窗    2

2    查看當前字元編碼    3

3    執行命令    4

 

 

oracle修改字元編碼

 

1. 開啟命令視窗

sqlplus shybt/[email protected]:1521/orcl

 

 

1. 查看當前字元編碼
   1. select userenv(‘language‘) from dual;

 

 

 

 

 

1. 執行命令

 

 

 

 

 

 

1. shutdown immediate;

1. startup mount
2. ALTER SYSTEM ENABLE RESTRICTED SESSION;
3. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

 

 

 

 

 

1. ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

 

1. ALTER SYSTEM SET AQ_TM_PROCESSES=0;
2. alter database open;

 

 

1. ALTER DATABASE character set INTERNAL_USE AL32UTF8;
2. shutdown immediate
3. startup

執行成功

oracle修改字元編碼