Shulou(Shulou.com)05/31 Report--

This article is to share with you about what CentOS7 did wrong when using exp/imp Times. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

It is strange to encounter an error when using the expstatement to export data under CentOS7, and the scripts used are scripts that have been validated in other environments.

1. Test environment

CentOS 7+Oracle11.2.0.3.0

Click (here) to collapse or open

[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 Wednesday November 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 statement reported an error

Click (here) to collapse or open

[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. Solve

You need to put double quotation marks in parentheses.

Click (here) to collapse or open

[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 Wednesday November 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] #

Thank you for reading! This is the end of the article on "what to do when CentOS7 uses the exp/imp Times wrong". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.