查看oracle服务器端字符集
客户端字符集
修改oracle10g字符集,在pl/sql下
- connect system as sysdba ;
- shutdown immediate ;
- startup mount ;
- alter system enable restricted session ;
- alter system set JOB_QUEUE_PROCESSES=0;
- alter system set AQ_TM_PROCESSES=0;
- alter database open ;
- alter database character set internal_use ZHS16GBK ;
- shutdown immediate ;
- startup ;
导入oracle10g中,注释变乱码 vi /etc/profile 添加环境变量