导出错误EXP-00091: Exporting questionable statistics

今天在客户那儿在数据库服务器上导出数据时发生EXP-00091，看看帮助[oracle@localhost backup]$ 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
[@more@]

估计是客户端字符集设置有问题，然后一看，果然数据库服务器(linux as3)上根本就没有设置客户端
字符集，于是在$HOME/.bash_profile中加入和数据库字符集一样的字符集：
export NLS_LANG=american_america.ZHS16GBK
使其生效：
[oracle@localhost backup]$ source /home/oracle/.bash_profile

这时导出就没有问题了

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/3898/viewspace-802754/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/3898/viewspace-802754/