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 ZHT16BIG5
step 02 根據step 01查出的NLS_CHARACTERSET(ZHT16BIG5)來設定
exp的環境變量:
WINNT> set NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
LINUX> export NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
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 ZHT16BIG5
step 02 根據step 01查出的NLS_CHARACTERSET(ZHT16BIG5)來設定
exp的環境變量:
WINNT> set NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
LINUX> export NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5