EXP-00091: Exporting questionable statistics.
1、查看oracle server NLS_LANG参数信息；以SYSDBA身份登录
view nls_parameters
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET'; PARAMETER VALUE ------------------------------ ------------------------------ NLS_CHARACTERSET AL32UTF8
2、修改环境变量
export NLS_LANG
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH ORACLE_BASE=/RealData ORACLE_HOME=$ORACLE_BASE/oracle ORACLE_SID=DATACENTER PATH=$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH DISPLAY=192.168.1.168:0.0 export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH DISPLAY alias sqlplus='rlwrap sqlplus' alias rman='rlwrap rman' #add enviroment variable nls_lang export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
3、导出数据文件
exp data successfully
[oracle@arcerzhang ~]$ exp ARCER/ARCER file=/RealData/backup/3.dmp Export: Release 11.2.0.1.0 - Production on Fri May 3 23:41:12 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user ARCER . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user ARCER About to export ARCER's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export ARCER's tables via Conventional Path ... . . exporting table COILS_ASSETS_DEPRECIATION 55 rows exported . . exporting table COILS_CODE_ASSESS 38 rows exported . . exporting table COILS_COMPANY_LICENSE 16 rows exported . . exporting table COILS_EMP 8 rows exported . . exporting table COILS_LOG_ASSESS 14 rows exported . . exporting table COILS_STORES 37 rows exported . . exporting table COMPANY_ANNOUNCEMENT 3 rows exported . . exporting table CRM_CUSTOMER 51 rows exported . . exporting table FGPS_EMPLOYEE 35 rows exported . . exporting table FGPS_FINANCEUNIT 3 rows exported . . exporting table FGPS_GROUP 20 rows exported . . exporting table FGPS_GROUP_VS_MENU 212 rows exported . . exporting table FGPS_MENU 51 rows exported . . exporting table FGPS_MYRECEIVER 40 rows exported . . exporting table FGPS_PEOPLE 800 rows exported . . exporting table FGPS_SYSTEMUSER 7 rows exported . . exporting table FGPS_USER 36 rows exported . . exporting table FGPS_USERGRANTACCOUNT 30 rows exported . . exporting table FGPS_VOUCHER 68 rows exported . . exporting table FRX_DEV_SUGGEST 26 rows exported . . exporting table FRX_OA_ATTENDANCE 4398 rows exported . . exporting table FRX_OA_DICT 473 rows exported . . exporting table FRX_OA_LOG_TEMPLATE 26 rows exported . . exporting table FRX_OA_WORKLOG 81 rows exported . . exporting table NETSTORE_INCOMEEXPENDITURELIST 227 rows exported . . exporting table SYSTEM_GROUP 35 rows exported . . exporting table SYSTEM_MENU 34 rows exported . . exporting table SYS_CATEGORY 33 rows exported . . exporting table SYS_GROUP_MENU_CORRESPONDENCE 100 rows exported . . exporting table WAITTINGHANDLER 50 rows exported . . exporting table WAITTING_HANDLER_DETAIL 78 rows exported . exporting synonyms . exporting views . exporting stored procedures . exporting operators . exporting referential integrity constraints . exporting triggers . exporting indextypes . exporting bitmap, functional and extensible indexes . exporting posttables actions . exporting materialized views . exporting snapshot logs . exporting job queues . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions . exporting statistics Export terminated successfully without warnings.
