注意,不是所有字符集都可以转的,要有子集和超集的关系的
[@more@]下面是大概的步骤:
1. sqlplus /nolog
2. conn /as sysdba;
3. startup;
4. @?/rdbms/admin/csminst.sql
5.
su oracle
$ cd $ORALE_HOME/bin
$ csscan full=y tochar=zhs32gb18030 array=1024000 process=2
这里需要用户密码:username/password as sysdba
6. @?/rdbms/admin/csalter.plb
7. shutdown;
8. startup;
11. sqlplus /nolog and conn /as sysdba and select userenv('language') from dual;
需要设置环境变量LD_LIBRARY_PATH
if [ $LD_LIBRARY_PATH ]; then
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/oracle/oracle/10g/lib; else
export LD_LIBRARY_PATH=/home/oracle/oracle/10g/lib;
fi
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7845854/viewspace-1039772/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7845854/viewspace-1039772/