今天在客户那儿在数据库服务器上导出数据时发生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@]
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/