EXP-00091: Exporting questionable statistics.

2023-10-23 08:40

本文主要是介绍EXP-00091: Exporting questionable statistics.,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

一.问题分析

      EXP时报这个错

[oracle@host01 ~]$ exp scott/tiger file=emp_dept.dmp tables=emp

Export: Release 11.2.0.3.0 - Production on Sun Jul 3 16:47:02 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing o
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                            EMP         14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
[oracle@host01 ~]$

二.MOS查询

转到底部转到底部

APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.2 [Release 9.0.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 13-Aug-2104***

SYMPTOMS

You received errors:

EXP-00091: Exporting questionable statistics

during export.

CAUSE

Beginning with Oracle 9i by default export attempts to include statistics in the export. In pre-Oracle 9i versions statistics are not included unless it is specified.

SOLUTION

a. If the statistics of a table are not required to be included in export, then take the export with parameter STATISTICS=NONE. Example:

#> exp scott/tiger file=emp1.dmp tables=emp STATISTICS=NONE

b. In case, the statistics are need to be included, you can use STATISTICS=ESTIMATE or COMPUTE (default is Estimate).

Note: The export will still generate the warning message about the questionable statistics in one of the following cases even if using STATISTICS=ESTIMATE / COMPUTE:

1. There are row errors while exporting

2. The client character set or NCHAR character set does not match the server character set or NCHAR character set (the NLS_LANG is different than the database character set for example).

3. A QUERY clause is specified

4. Only certain partitions or subpartitions are exported.

The situation in case 2 is the most frequent and can be solved by setting the NLS_LANG character set of the client to the character set of the database.

REFERENCES

BUG:1862413 - EXPORT & DEFAULT FOR STATISTICS SHOULD BE PRE-9I COMPATIBLE
NOTE:159787.1 - Import parameter: STATISTICS=SAFE

3.问题分析

    根据MOS和报错信息我们很明显看到这个报错是因为环境变量和数据库不一致或者环境变量未设置时导致的,因此有2种解决问题方案:
1.> 设置不到出统计信息
    2.> 设置正确的环境变量(一般用这种方式)

4.问题解决

第一种解决方案:

[oracle@host01 ~]$ . profile_rac 
[oracle@host01 ~]$ echo $NLS_LANG

[oracle@host01 ~]$  exp system/sys file=emp_dept.dmp tables=scott.emp
Export: Release 11.2.0.3.0 - Production on Sun Jul 3 17:26:30 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing o
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 ...
Current user changed to SCOTT
. . exporting table                            EMP         14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
[oracle@host01 ~]$
 exp system/sys file=emp_dept.dmp tables=scott.emp STATISTICS=NONE
Export: Release 11.2.0.3.0 - Production on Sun Jul 3 17:26:50 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing o
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 ...
Current user changed to SCOTT
. . exporting table                            EMP         14 rows exported
Export terminated successfully without warnings.
[oracle@host01 ~]$ 

第二种解决方案:

SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

PARAMETER                           VALUE
----------------------------------------------------------------
NLS_CHARACTERSET                    AL32UTF8
SQL>
或者:
SQL> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';
PARAMETER             VALUE
--------------------------------------------------------------------
NLS_CHARACTERSET      AL32UTF8
SQL> 
[oracle@host01 ~]$ echo $NLS_LANG

[oracle@host01 ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@host01 ~]$ echo $NLS_LANG
AMERICAN_AMERICA.AL32UTF8
[oracle@host01 ~]$ exp system/sys file=emp_dept.dmp tables=scott.emp
Export: Release 11.2.0.3.0 - Production on Sun Jul 3 17:23:50 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing o
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to SCOTT
. . exporting table                            EMP         14 rows exported
Export terminated successfully without warnings.
[oracle@host01 ~]$ 





这篇关于EXP-00091: Exporting questionable statistics.的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/266758

相关文章

linux 内核提权总结(demo+exp分析) -- 任意读写(四)

hijack_modprobe_path篇 本文转自网络文章,内容均为非盈利,版权归原作者所有。 转载此文章仅为个人收藏,分享知识,如有侵权,马上删除。 原文作者:jmpcall 专栏地址:https://zhuanlan.kanxue.com/user-815036.htm     原理同hijack_prctl, 当用户执行错误格式的elf文件时内核调用call_usermod

linux 内核提权总结(demo+exp分析) -- 任意读写(三)

hijack_prctl篇 本文转自网络文章,内容均为非盈利,版权归原作者所有。 转载此文章仅为个人收藏,分享知识,如有侵权,马上删除。 原文作者:jmpcall 专栏地址:https://zhuanlan.kanxue.com/user-815036.htm   prctl函数: 用户态函数,可用于定制进程参数,非常适合和内核进行交互 用户态执行prctl函数后触发prctl系统

linux 内核提权总结(demo+exp分析) -- 任意读写(二)

hijack_vdso篇 本文转自网络文章,内容均为非盈利,版权归原作者所有。 转载此文章仅为个人收藏,分享知识,如有侵权,马上删除。 原文作者:jmpcall 专栏地址:https://zhuanlan.kanxue.com/user-815036.htm     vdso: 内核实现的一个动态库,存在于内核,然后映射到用户态空间,可由用户态直接调用 内核中的vdso如果被修改

linux 内核提权总结(demo+exp分析) -- 任意读写(一)

cred篇 本文转自网络文章,内容均为非盈利,版权归原作者所有。 转载此文章仅为个人收藏,分享知识,如有侵权,马上删除。 原文作者:jmpcall 专栏地址:https://zhuanlan.kanxue.com/user-815036.htm   每个线程在内核中都对应一个线程结构块thread_infothread_info中存在task_struct类型结构体 struct t

linux 内核提权总结(demo+exp分析) -- ROP(二)

ret2usr CR4篇 本文转自网络文章,内容均为非盈利,版权归原作者所有。 转载此文章仅为个人收藏,分享知识,如有侵权,马上删除。 原文作者:jmpcall 专栏地址:https://zhuanlan.kanxue.com/user-815036.htm   smep: smep是内核的一种保护措施, 使得内核不可执行用户态代码 内核通过CR4寄存器的第20位来控制smep,

linux 内核提权总结(demo+exp分析) -- ROP(一)

基础ROP篇(linux 5.0.21) 本文转自网络文章,内容均为非盈利,版权归原作者所有。 转载此文章仅为个人收藏,分享知识,如有侵权,马上删除。 原文作者:jmpcall 专栏地址:https://zhuanlan.kanxue.com/user-815036.htm   内核提权与用户态攻击的区别 攻击流程 用户态攻击: 执行 system("/bin/sh") 获得shel

AtCoder Beginner Contest 369 D - Bonus EXP 动态规划

原题链接: https://atcoder.jp/contests/abc369/tasks/abc369_d 思路:   这道题为什么要用动态规划呢,其实,对于第i个怪物,我们有打与不打两种处理方式,而对于打,我们是获得两倍的经验值,还是一倍的经验值,与我们打了奇数只怪物还是打了偶数只怪物有关了,因此我们定义dp[i][0] 为前i只怪物总共打了偶数次,dp[i][1] 为前i只怪物总

【硬刚Hive】Hive基础(11):元数据(二)分析Hive表和分区的统计信息(Statistics)

类似于Oracle的分析表,Hive中也提供了分析表和分区的功能,通过自动和手动分析Hive表,将Hive表的一些统计信息存储到元数据中。 表和分区的统计信息主要包括:行数、文件数、原始数据大小、所占存储大小、最后一次操作时间等; 1 新表的统计信息 对于一个新创建的表,默认情况下,如果通过INSERT OVERWRITE的方式插入数据,那么Hive会自动将该表或分区的统计信息更新到元数据。

AUTOSAR_EXP_ARAComAPI的5章笔记(1)

5.1 High Level API Structure ara::com提供了一个支持AUTOSAR服务模型的API。服务有Method、Event、Filed和Trigger。 Method:在服务应用程序中执行一个可以返回值的函数(如校准方法)。 Event:当特定条件发生时(例如制动事件),服务应用程序发送一个事件(也可能包括一个值)。客户端应用程序可以订阅事件。 Filed:在

【译】PCL官网教程翻译(21):旋转投影统计(RoPs)特征 - RoPs (Rotational Projection Statistics) feature

英文原网址查看 旋转投影统计(RoPs)特征 在本教程中,我们将学习如何使用pcl::ROPSEstimation类来提取点特性。在这门课中实现的特征提取方法是由Yulan Guo, Ferdous Sohel, Mohammed Bennamoun, Min Lu and Jianwei Wanalso在他们的文章《旋转投影统计用于三维局部表面描述和目标识别》中提出的。 理论基础 特征提