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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 如何解決"Parse error: syntax error"Error
- Error-Expected resource of typeError
- 【shell 】syntax error in conditional expressionErrorExpress
- Vue : Expected the Promise rejection reason to be an ErrorVuePromiseError
- Syntax error, unrecognized expression: li[value=]ErrorZedExpress
- Solaris syntax error: unexpected end of fileError
- 帝國CMS提示parse error syntax error的解決方法Error
- fabirc error authorizing update: error validating ReadSet: readset expected key [Group] /Channel/AppErrorAPP
- 如何解決"You have an error in your SQL syntax"ErrorSQL
- 萬能方法解決——You have an error in your SQL syntaxErrorSQL
- Error: Expected ref to be a function, a string, an object returned by React.createRef(), or null.ErrorFunctionObjectReactNull
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- pecl PHP Parse error: syntax error, unexpected 'new' (T_NEW) 以及 XML缺失解決辦法PHPErrorXML
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- Solaris awk: syntax error near line 1 awk: bailing out near line 1ErrorAI
- 執行遷移檔案報錯: Syntax error or access violation: 1166 ...Error
- 360 Atals:Cause: java.sql.SQLException: Proxy Warning - near “status“: syntax errorJavaSQLExceptionError
- Syntax Error: ValidationError: Invalid options object. Stylus Loader has been initialized using anErrorObjectZed
- 解決laravel出現Syntax error or access violation: 1055 ‘***‘ isn‘t in GROUP BYLaravelError
- 正規表示式之(exp),(?:exp),(?=exp) 理解
- pbootcms模板 後臺升級程式後導致網站打不開 Parse error: syntax error, unexpecboot網站Error
- python匯入資料錯誤:ParserError: Error tokenizing data. C error: Expected 1 fields in line 3, saw 2PythonError
- eclipse 引入外部js檔案報Syntax error on token 錯解決方案EclipseJSError
- 帶庫升級 exp全備 su profile error lead to pkg failed to startErrorAI
- python關於Error tokenizing data. C error: Expected 10 fields in line 30, saw 31可能出現的問題PythonError
- PbootCMS 升級後網站打不開,解析錯誤 Parse error: syntax error, unexpected ‘:’, expecting ‘{’怎麼辦boot網站Error
- Linux:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannLinuxErrorMySqlServer
- Oracle TablesOracle
- Laravel 8使用 佇列任務出現 「 syntax error, unexpected ')' 」錯誤解決Laravel佇列Error
- Springboot中配置動態sql查詢出現的錯誤syntax error, expect ‘)‘Spring BootSQLError
- 錯誤內容:You have an error in your SQL syntax; check the manual that corresponds to your MySQL serverErrorMySqlServer
- Laravel5.4 資料庫遷移錯誤 SQLSTATE [42000] Syntax error or access violation 1071Laravel資料庫SQLError
- [報錯:字元太長] SQLSTATE [42000]: Syntax error or access violation: 1071 Specified key was t oo long;字元SQLError
- 7.84 EXP
- mysql關於FLUSH TABLES和FLUSH TABLES WITH READ LOCK的理解MySql
- 4.5.1.2.1 Syntax and Options
- 4.5.1.4.1 Syntax and Options
- A Tomcat 8.0 installation is expectedTomcat
- E. Expected Power