ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 解决exp-00091问题的方法(转载)

解决exp-00091问题的方法(转载)

原创 Linux操作系统 作者:nw5452 时间:2009-04-24 11:25:59 0 删除 编辑

step 01 查看DB中的NLS_CHARACTERSET的值(提供兩種方法):


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

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

请登录后发表评论 登录
全部评论

注册时间:2008-01-13

  • 博文量
    21
  • 访问量
    56443