分类: Oracle
2008-08-13 21:34:30
step 01 查看DB中的NLS_CHARACTERSET的值(提供兩種方法):
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'
or
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';PARAMETER VALUE
----------------------- ----------------------------------------------
NLS_CHARACTERSET ZHS16GBK
step 02 根據step 01查出的NLS_CHARACTERSET(ZHT16BIG5)來設定exp的環境變量:
WINNT> set NLS_LANG=american_america.ZHS16GBK
LINUX> export NLS_LANG=american_america.ZHS16GBK