Linux下导出数据库dmp文件时EXP-00091错误
Linux下导出数据库dmp文件时EXP-00091错误
解决办法:
1、查看DB的NLS_CHARACTERSET值:
SQL> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK
2、查看系统环境变量中的NLS_LANG值:
[Oracle@localhost ~]$ echo $NLS_LANG
Simplified Chinese_China.UTF8
3、设置环境变量中的NLS_LANG与数据库中的NLS_CHARACTERSET值相同:
[oracle@localhost ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
4、再次导出,无EXP-00091错误提示。
相关推荐
lbyd0 2020-11-17
sushuanglei 2020-11-12
腾讯soso团队 2020-11-06
gaobudong 2020-11-04
yangkang 2020-11-09
85477104 2020-11-17
KANSYOUKYOU 2020-11-16
wushengyong 2020-10-28
lizhengjava 2020-11-13
星月情缘 2020-11-13
huangxiaoyun00 2020-11-13
luyong0 2020-11-08
Apsaravod 2020-11-05
PeterChangyb 2020-11-05
wwwjun 2020-11-02
gyunwh 2020-11-02
EchoYY 2020-10-31
dingyahui 2020-10-30