EXP--解决EXP-00091的方法
来源:互联网 发布:越狱用户抹掉数据cydia 编辑:程序博客网 时间:2024/06/05 15:19
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
附上exp-91的oracle error message 解决方案说明:
oerr exp 91
00091, 00000, "Exporting questionable statistics."
// *Cause: Export was able export statistics, but the statistics may not be
// usuable. The statistics are questionable because one or more of
// the following happened during export: a row error occurred, client
// character set or NCHARSET does not match with the server, a query
// clause was specified on export, only certain partitions or
// subpartitions were exported, or a fatal error occurred while
// processing a table.
// *Action: To export non-questionable statistics, change the client character
// set or NCHARSET to match the server, export with no query clause,
// export complete tables. If desired, import parameters can be
// supplied so that only non-questionable statistics will be imported,
// and all questionable statistics will be recalculated.
From:http://tonykorn97.itpub.net/post/6414/408193
- EXP--解决EXP-00091的方法 (转贴)
- EXP--解决EXP-00091的方法
- EXP--解決EXP-00091的方法
- 解決EXP-00091的方法
- ORCALE 几个错误的解决笔记:EXP-00091, EXP-00015, EXP-00001
- EXP-00091-错误解决
- 解决exp-00091办法
- exp时EXP-00091: 错误的处理
- 解決EXP-00091的方法【转】
- 【EXP】exp-00091解决办法
- 【DB.Oracle】解决EXP-00091
- Oracle11gR2用EXP导出时报EXP-00011错误的解决
- Oracle11gR2用EXP导出时报EXP-00011错误的解决
- EXP
- exp
- EXP
- exp
- exp
- CSS中的优先级(有些翻译为特殊性
- android中任何禁止软键盘自动弹出而点击EditText的时候才弹出
- POJ 1185 炮兵阵地(状态压缩)
- POJ 3737 UmBasketella 三分
- 字节和字符的来源
- EXP--解决EXP-00091的方法
- MATLAB的cat()函数
- SAP HANA HDB序列的使用方法及技巧(SAP HANA HDB SEQUENCE )
- android MediaPlayer详解
- Oracle笔记
- C++0x(C++11)中对多线程的支持
- 动态规划算法的优化技巧
- javascript 判断 脚本加载请求是否健康
- Configuration of Video Device on S8 X86