EXP-00091

Posted by Vincent on July 24, 2008

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    AL32UTF8

step 02 根據step 01查出的NLS_CHARACTERSET(AL32UTF8)來設定exp的環境變量:

WINNT> set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

LINUX> export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

可以在.profile 中增加 NLS_LANG=AMERICAN_AMERICA.AL32UTF8; export NLS_LANG

这样就省事很多,不用每次exp的时候都写一次。


This work is licensed under a CC A-S 4.0 International License.