今天exp数据的时候出现错误:EXP-00091: Exporting questionable statistics.
查看一下错误:
[oracle@testdb ~]$ 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.
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.
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET
[oracle@testdb ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
再exp之后就没有出现错误了。
[oracle@testdb ~]$ exp xxxxx/xxxxx file=smeso.dmp
Export: Release 11.2.0.1.0 - Production on Fri Nov 2 09:59:47 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. . exporting table DICT_CHAR_CODE 6841 rows exported
...................................................................................................................
. exporting materialized views
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
Export: Release 11.2.0.1.0 - Production on Fri Nov 2 09:59:47 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. . exporting table DICT_CHAR_CODE 6841 rows exported
...................................................................................................................
. exporting materialized views
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.