EXP-00091和IMP-00010解决方法
日期：2014-05-16 浏览次数：20441 次
EXP-00091和IMP-00010解决办法
在session4的4小题需要用到SH.COUNTRIES表，而手工建库时，这个SH用户没有这个表，就想着将别处的这个表拷贝过来。
原来导出表的库：database ORACLE_SID=TEST0221 版本： 11.2.0.4
需要导进的库：database ORACLE_SID=PROD 版本：10.2.0.1
因为字符集的问题，出现了EXP-00091的错误
因为数据库版本的问题，出现了IMP-00010的错误
[oracle@node2 ~]$ exp sh/sh@test0221 tables=COUNTRIES rows=y file=COUNTRIES.dmp
Export: Release 11.2.0.4.0 - Production on Thu Mar 27 15:19:07 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table COUNTRIES 23 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
[oracle@node2 ~]$ 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@node2 ~]$ exit
exit
sys@TEST0221> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
PARAMETER VALUE
------------------------------ -------------------------------------------------------------------
NLS_CHARACTERSET AL32UTF8
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
