在linux 使用exp导出备份数据时提示:
EXP-00091: Exporting questionable statistics.
1.问题产生的原因
linux下oracle用户环境变量语言集和oracle数据库中的环境变量语言集不同
2.解决方法
只要将oracle环境变量语言集改成和数据库环境变量语言集一样的就可以
查看服务端字符集select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'
orselect * from v$nls_parameters where parameter='NLS_CHARACTERSET';
[oracle@rac01 ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@rac01 ~]$ exp tuser/****** tables=UCM_BOARDWS_INSTALLWORK,UCM_BOARDWS_APINSTALL file=/orabak/1015installworkBak.dmp log=/orabak/1015installworkBak.log
Export: Release 11.2.0.3.0 - Production on Wed Oct 15 10:05:16 2014
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 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table UCM_BOARDWS_INSTALLWORK 1998871 rows exported
. . exporting table UCM_BOARDWS_APINSTALL 2190269 rows exported
Export terminated successfully without warnings.
相关推荐
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 ...
Linux系统下导出ORACLE数据库出现Exporting questionable statistics.错误 处理
并附上启动和关闭Linux命令 jquery-1.10.2.min.js moment.min.js bootstrap.min.js highstock.js exporting.js lodash.min.js 修改start.sh脚本 #!/bin/bash java -Xms512M -Xmx512M -Xss1024K -XX:PermSize=256m...
网上下载的 highcharts.js;draggable-legend.js;exporting.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
highchars图表用到的基础js,还有其他js需要用到的会一同上传
编辑解析器 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
已修改jar包里面offsetapp文件夹中的index.html页面中引用的线上文件地址,改为本地下载好的离线文件,无网络环境也能启动,修改文件包括: bootstrap.min.css angular.js ...exporting.js lodash-2.4.1.js
Poppler is targeted primarily for the Linux environment, but the developers have included Windows support as well in the source code. Getting the executables (exe) and/or dlls for the latest version ...
WorldComposer is a tool to extract height...- Exporting is Multi-Thread. - Automatic version update inside WorldComposer. - Works with TerrainComposer (as an extension). - Works with RTPv3 (Optional).
文档描述:Exporting a Storyboard Project as an Android Application Crank是一家致力于创新嵌入式图形用户界面解决方案的软件公司。Crank软件提供的产品和服务,使得UI设计者和开发设计团队能够在资源受限的...
- 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 ...
Advanced Linux 3D graphics programming Chapter 1 Basic Linux 3D Graphics Concepts ..................1 2D Graphics Fundamentals ......................................1 3D Graphics Fundamentals ...........
Highcharts-export-module-asp.net, 在你自己的ASP.NET 服务器上,该模块允许你导出图表 Tek4.Highcharts.Exporting 程序集Tek4 ASP.NET ( http://highcharts.com/ )的导出模块。 版本 1.0.2.0 ( 3,2012 )基于 ASP...
gitlab项目导出 简单的python项目,用于通过GitLab API中的Export Project功能导出gitlab项目。 主要用于将GitLab.com中的项目远程备份到私有存储服务器。 重大变化 05-2020 已修改代码以与Python3一起使用,而...
DkZ Studio: - Fixed Link to rebuild function (save as...) in help bar. DataBase Editor: - Added WE/PES PC compatibility. ...- Fixed the team names (exporting teams) when it have utf-8 chars.
Exporting Resources .......................................................................................................................... 2-5 Using the Export Wizard ................................