ITPub博客

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

EXP-00091: Exporting questionable statistics

原创 Linux操作系统 作者:todayboy 时间:2012-03-02 09:28:52 0 删除 编辑

 cat EXP_P2011.sh
#!/bin/bash

NLS_LANG=AMERICAN_AMERICA.UTF8 ;export  NLS_LANG

/u01/app/oracle/product/10.2.0/db_1/bin/exp hmbarcode/hmbarcode file=/u02/backup/MasterP2011_`date +%Y%m%d`.dum  tables=barcode_master:p2011  log=/u02/backup/MasterP2011_exp.log

log:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                 BARCODE_MASTER
. . exporting partition                          P2011   40971548 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

 

把一个大表进行分区,备份分区表时,出现这个问题,不知如何解决!

 

解决:

ID 730106.1中记录了解决方法,选了个比较简单的在导出命令后加statistics=none

ID 730106.1中的部分片段:
The pre-calculated optimizer statistics are flagged as questionable at export time if:
1. There are row errors while exporting.


2. The client characterset or NCHAR characterset does not match the server characterset or NCHAR characterset.


3. A QUERY clause is specified.


4. Only certain partitions or subpartitions are exported

我是一个分区表的一个分区! 

 

reference:http://blog.csdn.net/lwei_998/article/details/6334157

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

上一篇: keep池 [转]
请登录后发表评论 登录
全部评论

注册时间:2009-02-24

  • 博文量
    75
  • 访问量
    244764