对DBA或需使用exp,imp的普通用戶來说,在我们做exp的過程中可能经常会遇到EXP-00091 Exporting questionable statistics.这样的EXP信息,其实它就是exp的error message,它产生的原因是因为我们exp工具所在的环境变量中的NLS_LANG与DB中的NLS_CHARACTERSET不一致。
问题:
lpding-> exp scott/scott file=/oracle/exp/scott_emp.dmp log scott_emp.log tables=emp
Export: Release 10.2.0.1.0 - Production on Tue Jun 29 15:07:38 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK 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.
解决:
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
------------------------------- ---------------------------------------------------------------------------------------------------
NLS_CHARACTERSET ZHS16GBK
SQL> host
lpding-> export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
lpding-> exp scott/scott file=/oracle/exp/scott_emp.dmp log scott_emp.log tables=emp
Export: Release 10.2.0.1.0 - Production on Tue Jun 29 15:32:08 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table EMP 14 rows exported
Export terminated successfully without warnings.
lpding->
相关推荐
NULL 博文链接:https://xujq.iteye.com/blog/1714222
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 ...
Exporting package bzip2:x86-windows... Exporting package zlib:x86-windows... Exporting package libpng:x86-windows... Exporting package freetype:x86-windows... Creating zip archive... Zip archive ...
更新上个angular版本问题 本地化所有需网络请求的JS,包括被墙了的 angular.js, angular-route.js, angular-resource.js。并附上启动和关闭Linux命令 jquery-1.10.2.min.js moment.min.js bootstrap.min.js ...
Create visually appealing and feature-rich ...Discover cross-platform development by exporting the Qt 5 application to different platforms Uncover the secrets behind debugging Qt 5 and C++ applications
Linux系统下导出ORACLE数据库出现Exporting questionable statistics.错误 处理
网上下载的 highcharts.js;draggable-legend.js;exporting.js,
已修改jar包里面offsetapp文件夹中的index.html页面中引用的线上文件地址,改为本地下载好的离线文件,无网络环境也能启动,修改文件包括: bootstrap.min.css angular.js ...exporting.js lodash-2.4.1.js
1 What is Liferay? 1 1.1 Building a site with Liferay Web Content . . . . . . . ....1.2 Using Liferay Portal as a collaborative platform ....1.3 Using Liferay as a social platform ....1.4 Using Liferay as a ...
Exporting Resources .......................................................................................................................... 2-5 Using the Export Wizard ................................
rman的数据文件恢复记录, 只是xshell日志不要下载
title)),None,None,Some(Credits(None,,None,None,)),Some(Exporting(chart,None,None,None,None,None,None)),Some(Legend(None,None,None,Some(false),None,None,None,None,None,None,None,None,None,None,None,...
exporting it_fieldcatalog = ifc importing ep_table = dy_table. assign dy_table->* to <dyn_table>. create data dy_line like line of <dyn_table>. assign dy_line->* to <dyn_wa>. 申明:文档...
- Exporting of data to source code (Pascal, C, Java, C#, VB.NET) or as formatted output (plain text, HTML, Richtext, TeX) or to hex formats Motorola S19 Records, Motorola S28 Records, Motorola S37 ...
编辑解析器 Nodejs edi 解析器 平台:Node.js 前端:Angular.js Web ...excel-export-imp - Deals with exporting as excel JSON Path - Extracts paths out of JSON file xml2js - Parses xml ejs- template engine
- fixed memory leak when exporting to PDF with embedded fonts - fixed bug with band break - fixed bug with information fields in the encrypted PDF file - fixed bug with page borders and fill in the...
Chapter 19 Importing and Exporting Data Chapter 20 Data Filtering and Manipulation Chapter 21 Working with Curated Data Chapter 22 Using Wolfram|Alpha Data in Mathematica Chapter 23 Statistical ...
Exporting and Importing Blender Models............................36 Summary...............................................37 Chapter 2 Rendering and Animation Techniques for 3D Polygons ......39 ...
文档描述:Exporting a Storyboard Project as an Android Application Crank是一家致力于创新嵌入式图形用户界面解决方案的软件公司。Crank软件提供的产品和服务,使得UI设计者和开发设计团队能够在资源受限的...