常见情形:从服务器备份oracle后再到本地机器上还原oracle数据库的时候经常会碰见数据库字符编码不一致的情况,可以用以下命令来修改本地的oracle数据库字符编码,然后顺利还原oracle数据库到本地机器上
操作指令:
sql> conn /as sysdba;
sql>select userenv(‘language’) from dual;
sql>shutdown immediate
sql>startup mount
sql>alter system enable restricted session;
sql>alter system set job_queue_processes=0;
sql>alter system set aq_tm_processes=0;
sql>alter database open;
sql>alter database character set internal_use us7ascii;
sql>shutdown immediate;
sql>startup;
sql>select userenv(‘language’) from dual;
常见的oracle字符集有zhs16gbk、al32utf8、us7ascii等?