exp tables sh: Syntax error: `(' is not expected
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- CentOS7使用exp/imp時報錯:bash: syntax error near unexpected token `(CentOSError
- exp.sh 指令碼指令碼
- Error-Expected resource of typeError
- 如何解決"Parse error: syntax error"Error
- DB2:SQL1024N和ksh: 0403-057 Syntax error: `(' is not expected.報錯DB2SQLError
- Syntax error, unrecognized expression: li[value=]ErrorZedExpress
- syntax error near unexpected token `Error
- 【shell 】syntax error in conditional expressionErrorExpress
- Vue : Expected the Promise rejection reason to be an ErrorVuePromiseError
- Solaris syntax error: unexpected end of fileError
- Oracle安裝報錯syntax errorOracleError
- EXP error EXP-00003 EXP-00091 EXP-00015Error
- exp_00091 errorError
- exp/imp expdp/impdp Tables 萬用字元 % 的使用字元
- expdp report error when export tablesErrorExport
- 帝國CMS提示parse error syntax error的解決方法Error
- line 10:syntax error: unexpected end of fileError
- 如何解決"You have an error in your SQL syntax"ErrorSQL
- 配置NDK syntax error: unexpected end of file 解決Error
- exp/imp expdp/impdp Tables 萬用字元 % 的使用【Blog 搬家】字元
- 萬能方法解決——You have an error in your SQL syntaxErrorSQL
- syntax error near unexpected token `問題的解決Error
- error C2061: syntax error : identifier '__RPC__out_xcount_part'ErrorIDERPC
- EXP-00006: internal inconsistency errorError
- EXP-00056: ORACLE error 904 encounteredOracleError
- EXP-00008: ORACLE error 6550 encounteredOracleError
- fabirc error authorizing update: error validating ReadSet: readset expected key [Group] /Channel/AppErrorAPP
- shell 指令碼報錯^M: syntax error near unexpected token指令碼Error
- Android Studio 打包APK遇到Error: Expected resource of type id [ResourceType]AndroidAPKError
- Error: Expected ref to be a function, a string, an object returned by React.createRef(), or null.ErrorFunctionObjectReactNull
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- 隨記EXP-00008: ORACLE error 6550 encounteredOracleError
- AIX 11gR2 grid root.sh Error: with status:FAIL.Error code is 256AIError
- 解決laravel出現Syntax error or access violation: 1055 ‘***‘ isn‘t in GROUP BYLaravelError
- 360 Atals:Cause: java.sql.SQLException: Proxy Warning - near “status“: syntax errorJavaSQLExceptionError
- mysqldump: Got error: 1168 differently defined non-MyISAM LOCK TABLESMySqlGoError
- EXP-00056: ORACLE error 600 encountered 解決方法OracleError