oracle数据库在hp-ux平台进行exp的时候,当导出的表超过1个时,总会报错,在windows平台没有此问题,之前改用parfile进行处理,但是如果表数量很少的话,比较麻烦,查询了一下处理办法,记录如下:
1. hp-unix 平台
oracle@test2[/oracle]$ exp leiz/leiz@test2 file=./test.dmp tables=('sup_his_tool','sup_tool')
sh: Syntax error: `(' is not expected.
oracle@test2[/oracle]$ exp leiz/leiz@testdb2 file=./test.dmp tables="sup_his_tool,sup_tool"
Export: Release 10.2.0.4.0 - Production on Thu Apr 22 16:43:58 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table SUP_HIS_TOOL 226 rows exported
. . exporting table SUP_TOOL 25 rows exported
Export terminated successfully without warnings.
2. windows 平台
C:\Documents and Settings\GA>exp leiz/leiz@leiz_db file=c:\test.dmp tables=('sup_his_tool','sup_tool')
Export: Release 10.2.0.4.0 - Production on 星期四 4月 22 16:32:23 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即将导出指定的表通过常规路径...
. . 正在导出表 SUP_HIS_TOOL导出了 226 行
. . 正在导出表 SUP_TOOL导出了 25 行
成功终止导出, 没有出现警告。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9252210/viewspace-660458/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9252210/viewspace-660458/