Oracle EXP：ORA-01013: user requested cancel of current operation
导入导出的时候，可能会遇到这样的错误：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
[oracle@xxx backup]$ exp system/oracle file=dump_20170817_vpx.dmp tablespaces=vpx （过多的输出，...） EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_RULE_QUALIFIER 0 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_SCOPE 216 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_TRAFFIC_FILTER_CONFIG 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_TRAFFIC_FILTER_PARAM 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_UPLINK 4 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_VMVNIC_RES_POOL 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_VSPAN_PORTS 0 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table VPX_DVS_VSPAN_SESSION 0 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. . . exporting table VPX_ENTITY 1881 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. （过多的输出，...） |
设置NLS_LANG：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
[oracle@xxx backup]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 17 17:21:31 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select userenv('language') from dual; USERENV('LANGUAGE') -------------------------------------------------------------------------------- AMERICAN_AMERICA.WE8MSWIN1252 SQL> SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@xxx backup]$ [oracle@xxx backup]$ export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252 [oracle@xxx backup]$ |
再次执行导出就没问题了：
[crayon-60807f059dad60101282[……]
