在我们对Oracle做EXP的过程中,可能会经常遇到EXP-00091 Exporting questionable statistics.的信息,其实它就是exp的error message,它产生的原因是因为我们exp工具所在的环境变量是的NLS LANG中的NLS_CHARCATERSET不一致引起的。但需要说明的是,EXP-00091这个error对所生成的dump文件没有影响,生成的dump文件还可以正常imp。
下面我们来解决这个问题,让其不再出现:
第一步:
查看DB中的NLS_CHARACTERSET的值(提供两种方法):
查询NLS_CHARACTERSET的值:
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'
or
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
----------------------- ----------------------------------------------
NLS_CHARACTERSET AL32UTF8
第二步:
根据第一步查出的NLS_CHARACTERSET(AL32UTF8)来设定exp的环境变量:
WINNT> set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
查看:echo %NLS_LANG%
进行设定后,在环境变量中查看NLS_LANG的值是否一致,如果不一致可在环境变量中手中修改。
LINUX> export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
查看:echo $NLS_LANG
或在 .bash_profile中增加上export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 即可解决问题。
--按用户导出
[oracle@oracle ~]$ exp 用户名/密码 file=/home/oracle/20130618.dmp owner=用户名
相关推荐
EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table DEPT 4 rows exported . . exporting table EMP 17 rows exported . . exporting table GOODS ...
Linux系统下导出ORACLE数据库出现Exporting questionable statistics.错误 处理
文档描述:Exporting a Storyboard Project as an Android Application Crank是一家致力于创新嵌入式图形用户界面解决方案的软件公司。Crank软件提供的产品和服务,使得UI设计者和开发设计团队能够在资源受限的...
- Fixed exporting of Unicode characters to ODF for non-Unicode IDE - Fixed exporting of text with empty lines at the end to XLSX + Added TfrxPrintMode support in the frxClassRTTI - Fixed access to...
python-django-exporting-files 这是一个Python / Django应用程序,它显示了导出Excel和PDF文件的简单程度。 为了创建Excel文件,我们使用模块。 该代码包含有关如何将数据添加到Excel文件,如何调整列和行的大小...
Exporting TUs 2-9 Chapter 3: Language Resources What are Language Resources? 3-2 Creating a Language Resource Template 3-2 Creating a TM Based on a Language Resource Template 3-4 Using Variables ...
网上下载的 highcharts.js;draggable-legend.js;exporting.js,
- Fixed exporting of fsAltDot frame line style in the PDF export - Fixed C++ Builder compatibility [6.4.7 - 6.4.9] - Fixed division by zero in the PDF export [6.4.4 - 6.4.6] - Fixed wrong behaviour of...
- Fixed exporting of fsAltDot frame line style in the PDF export - Fixed C++ Builder compatibility [6.4.7 - 6.4.9] - Fixed division by zero in the PDF export [6.4.4 - 6.4.6] - Fixed wrong behaviour of...
- Fixed exporting of fsAltDot frame line style in the PDF export - Fixed C++ Builder compatibility [6.4.7 - 6.4.9] - Fixed division by zero in the PDF export [6.4.4 - 6.4.6] - Fixed wrong behaviour of...
- Fixed exporting of fsAltDot frame line style in the PDF export - Fixed C++ Builder compatibility [6.4.7 - 6.4.9] - Fixed division by zero in the PDF export [6.4.4 - 6.4.6] - Fixed wrong behaviour of...
CMake的Importing and Exporting Guide指南对应的源码,源文件路径:@repo CMake github/Help/guide/importing-exporting
highchars图表用到的基础js,还有其他js需要用到的会一同上传
参数 参数解释 svg SVG 字符串,当指定了 options 参数是该参数将会被忽略 options 图表配置 type 导出文件的类型,可以是 'image/png'、'image/jpeg'、'application/pdf' 或 'image/svg+xml' 中的一个 ...
DW2XLS 4.0 release notes. New features in 4.0 - Added support for the new Excel file format, OOXML (XML based Excel 2007 ...- When exporting to OOXML format, inserting pictures is not yet supported.
EFS-PV-PORTING脚本 efs-pv-porting可以导出当前群集PV(持久卷)并导入新群集。... -e / --export Exporting PV in old cluster ex) ./run.py -e export_file // ./run.py --export export_file -i / --import Impo
Excel Importing & Exporting Text Data ---Quickly Turn Raw Data Into Excel Tables, By Scott Hartshorn, epub格式版。