宜宾网站建设公司

CentOS7使用exp/imp时报错怎么办

这篇文章给大家分享的是有关CentOS7使用exp/imp时报错怎么办的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。

让客户满意是我们工作的目标，不断超越客户的期望值来自于我们对这个行业的热爱。我们立志把好的技术通过有效、简单的方式提供给客户，将通过不懈努力成为客户在信息化领域值得信任、有价值的长期合作伙伴，公司提供的服务项目有：域名注册、网页空间、营销软件、网站建设、科尔沁网站维护、网站推广。

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

1.测试环境

CentOS 7+Oracle11.2.0.3.0

点击(此处)折叠或打开

  1. [root@localhost hoegh]# cat /etc/centos-release

  2. CentOS Linux release 7.2.1511 (Core)

  3. [root@localhost hoegh]#

  4. [root@localhost hoegh]# sqlplus sys/sys as sysdba

  6. SQL*Plus: Release 11.2.0.3.0 Production on 星期三 11月 1 11:43:51 2017

  8. Copyright (c) 1982, 2011, Oracle. All rights reserved.

  11. Connected to:

  12. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

  13. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  15. SQL> select * from v$version;

  17. BANNER

  18. --------------------------------------------------------------------------------

  19. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

  20. PL/SQL Release 11.2.0.3.0 - Production

  21. CORE    11.2.0.3.0    Production

  22. TNS for Linux: Version 11.2.0.3.0 - Production

  23. NLSRTL Version 11.2.0.3.0 - Production

  25. SQL>

  26. SQL>

  27. SQL> exit

  28. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

  29. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  30. [root@localhost hoegh]#

2.exp语句报错

点击(此处)折叠或打开

  1. [root@localhost hoegh]#

  2. [root@localhost hoegh]# exp hoegh/hoegh tables=(HOEGH1,HOEGH2,HOEGH3,HOEGH4,HOEGH5) file=/home/hoegh/hoegh.dmp

  3. bash: syntax error near unexpected token `(

3.解决

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

点击(此处)折叠或打开

  1. [root@localhost hoegh]#

  2. [root@localhost hoegh]# exp hoegh/hoegh tables="(HOEGH1,HOEGH2,HOEGH3,HOEGH4,HOEGH5)" file=/home/hoegh/hoegh.dmp

  4. Export: Release 11.2.0.3.0 - Production on 星期三 11月 1 11:44:58 2017

  6. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

  9. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

  10. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  11. Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

  13. About to export specified tables via Conventional Path ...

  14. . . exporting table HOEGH1          2 rows exported

  15. . . exporting table HOEGH2        500 rows exported

  16. . . exporting table HOEGH3       1500 rows exported

  17. . . exporting table HOEGH4          2 rows exported

  18. . . exporting table HOEGH5        500 rows exported

  19. Export terminated successfully without warnings.

  20. [root@localhost hoegh]#

感谢各位的阅读！关于“CentOS7使用exp/imp时报错怎么办”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，让大家可以学到更多知识，如果觉得文章不错，可以把它分享出去让更多的人看到吧！


本文名称：CentOS7使用exp/imp时报错怎么办
文章来源：http://ybzwz.com/article/gjdhop.html

其他资讯