今天在CentOS7下使用exp语句导出数据时遇到报错,使用的脚本都是其他环境下验证过的脚本,很是奇怪。
~~~~~~~ the end~~~~~~~~~
hoegh
2017.11.1
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 `(
3.解决
需要在括号上添 加双引号才行。点击(此处)折叠或打开
- [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
-
- 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, 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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30162081/viewspace-2146700/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30162081/viewspace-2146700/