| 标题 | EXP-00091: Exporting questionable statistics |
| 内容 | 一.出现EXP-00091错误 [oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT > file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:02:37 2012 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses ZHS16GBK character set (possible charset conversion) About to export specified tables via Conventional Path ... Current user changed to TESTXUCHAO . . exporting table TAB_XN_PY_DICT 25433 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. Export terminated successfully with warnings. 当环境变量和数据库的不一致，在导出统计信息时候，会报EXP-00091错误。 二.查看NLS相关参数 [oracle@localhost tmp]$ echo $NLS_LANG AMERICAN SQL> col value for a30 SQL> select parameter,value from nls_database_parameters 2 where parameter like '%CHARACTERSET%'; PARAMETER VALUE ------------------------------ ------------------------------ NLS_CHARACTERSET ZHS16GBK NLS_NCHAR_CHARACTERSET AL16UTF16 三.解决方法 1.设置NLS_LANG为NLS_CHARACTERSET [oracle@localhost tmp]export NLS_LANG=american_america.ZHS16GBK [oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT > file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:10 2012 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified tables via Conventional Path ... Current user changed to TESTXUCHAO . . exporting table TAB_XN_PY_DICT 25433 rows exported Export terminated successfully without warnings. 2.使用statistics=none [oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT > file=/tmp/xifenfei.dmp log=/tmp/xifenfei.log statistics=none Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:53 2012 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses ZHS16GBK character set (possible charset conversion) About to export specified tables via Conventional Path ... Current user changed to TESTXUCHAO . . exporting table TAB_XN_PY_DICT 25433 rows exported Export terminated successfully without warnings. |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。