exp tables sh: Syntax error: `(' is not expected

zhanglei_itput發表於2010-04-22

    oracle資料庫在hp-ux平臺進行exp的時候,當匯出的表超過1個時,總會報錯,在windows平臺沒有此問題,之前改用parfile進行處理,但是如果表數量很少的話,比較麻煩,查詢了一下處理辦法,記錄如下:

1. hp-unix 平臺
exp file=./test.dmp tables=('sup_his_tool','sup_tool') 
sh: Syntax error: `(' is not expected.

exp 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 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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章