1、问题原因
该提示是因为当前的环境变量NLS_LANG和数据库字符language不一致造成的，查看当前的数据字符集
1
2
3
4
| 10:56:39 SYS@ boston> Select userenv('LANGUAGE') FROM DUAL;
USERENV('LANGUAGE')
AMERICAN_AMERICA.ZHS16GBK
|
2、查看当前的环境变量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
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
| [oracle@node3 bin]$ echo $NLS_LANG
[oracle@node3 bin]$
值为空，设置该值于数据库字符集语言一致，再次使用exp导出
[oracle@node3 bin]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@node3 bin]$ ./exp test/Test12345678@boston177 file=/tmp/daochu.dmp log=/tmp/daochu.log
Export: Release 11.2.0.3.0 - Production on Thu Sep 5 10:57:41 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. 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
Export done in ZHS16GBK 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 TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Conventional Path ...
. . exporting table TEST 3 rows exported
. . exporting table TEST1 0 rows exported
. . exporting table TEST2 0 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.
|
导出正常