版權聲明：轉載時請以超連結形式标明文章原始出處和作者資訊及本聲明
http://blog.csdn.net/wenshuangzhu/article/details/44060625
使用EXP指令導出VMSPUBL使用者模式下的所有對象，日志記錄導出過程中報錯：
EXP-00091: Exporting questionable statistics.
##############################################################################
Export Start.
Start Time: 2013-08-07 09:35:01
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in UTF8 character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: indexes on tables will not be exported
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user VMSPUBL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user VMSPUBL
About to export VMSPUBL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export VMSPUBL's tables via Conventional Path ...
. . exporting table VMS_ADMIN_OPER_LOG
51 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table VMS_APP_LOG
0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table VMS_BULLETIN_COS
0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table VMS_CALLOUT_FAX
0 rows exported
............
檢視EXP-00091的oracle error message：
[email protected]:~> oerr exp 00091
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.
檢視oracle環境變量NLS_LANG：
[email protected]:~> echo $NLS_LANG
AMERICAN_AMERICA.UTF8
檢視DB的NLS_CHARACTERSET：
SQL> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
PARAMETER VALUE
------------------------------ ----------------------------------
NLS_CHARACTERSET AL32UTF8
兩者不一緻。
編輯/home/oracle/.profile，修改oracle環境變量NLS_LANG：
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
重新執行EXP導出，未再報EXP-00091錯誤。
##############################################################################
Export Start.
Start Time: 2013-08-07 10:03:53
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in AL32UTF8 character set and UTF8 NCHAR character set
Note: indexes on tables will not be exported
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user VMSPUBL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user VMSPUBL
About to export VMSPUBL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export VMSPUBL's tables via Conventional Path ...
. . exporting table VMS_ADMIN_OPER_LOG
51 rows exported
. . exporting table VMS_APP_LOG
0 rows exported
. . exporting table VMS_BULLETIN_COS
0 rows exported
...................
Export terminated successfully without warnings.
Export End.
End Time: 2013-08-07 10:04:12
##############################################################################
![oracle中的start with connect by用法[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)