今天在CentOS7下使用exp语句导出数据时遇到报错，使用的脚本都是其他环境下验证过的脚本，很是奇怪。

1.测试环境

CentOS 7+Oracle11.2.0.3.0

点击(此处)折叠或打开

[root@localhost hoegh]# cat /etc/centos-release
CentOS Linux release 7.2.1511 (Core)
[root@localhost hoegh]#
[root@localhost hoegh]# sqlplus sys/sys as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on 星期三 11月 1 11:43:51 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[root@localhost hoegh]#

2.exp语句报错

点击(此处)折叠或打开

[root@localhost hoegh]#
[root@localhost hoegh]# exp hoegh/hoegh tables=(HOEGH1,HOEGH2,HOEGH3,HOEGH4,HOEGH5) file=/home/hoegh/hoegh.dmp
bash: syntax error near unexpected token `(

需要在括号上添加双引号才行。

点击(此处)折叠或打开

[root@localhost hoegh]#
[root@localhost hoegh]# exp hoegh/hoegh tables="(HOEGH1,HOEGH2,HOEGH3,HOEGH4,HOEGH5)" file=/home/hoegh/hoegh.dmp
Export: Release 11.2.0.3.0 - Production on 星期三 11月 1 11:44:58 2017
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.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 tables via Conventional Path ...
. . exporting table HOEGH1 2 rows exported
. . exporting table HOEGH2 500 rows exported
. . exporting table HOEGH3 1500 rows exported
. . exporting table HOEGH4 2 rows exported
. . exporting table HOEGH5 500 rows exported
Export terminated successfully without warnings.
[root@localhost hoegh]#

~~~~~~~ the end~~~~~~~~~
hoegh
2017.11.1