ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP-00091: exporting questionable statistics

EXP-00091: exporting questionable statistics

原创 Linux操作系统 作者:wshxgxiaoli 时间:2012-07-05 14:12:09 0 删除 编辑
1.在EXP 导出时遇见“EXP-00091: Exporting questionable statistics.” 错误
解决办法:未设置NLS_LAN
select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
修改用户环境文件:
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
执行用户环境文件:
source ../.bash_profile
再次导出
exp hr/hr file=exp_full2.dmp log=exp_full.log direct=y recordlength=65535

Export: Release 11.2.0.1.0 - Production on Tue Apr 10 13:33:37 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 ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user HR
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user HR
About to export HR's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export HR's tables via Direct Path ...
. . exporting table                      COUNTRIES         25 rows exported
. . exporting table                    DEPARTMENTS         27 rows exported
. . exporting table                      EMPLOYEES        107 rows exported
. . exporting table                           JOBS         19 rows exported
. . exporting table                    JOB_HISTORY         10 rows exported
. . exporting table                      LOCATIONS         23 rows exported
. . exporting table                        REGIONS          4 rows exported
. . exporting table                          TEST1          0 rows exported
. . exporting table                         TEST23        107 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
再无警告信息。

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

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

注册时间:2012-03-30

  • 博文量
    33
  • 访问量
    51777