IMP-00017: following statement failed with ORACLE error 957錯誤的解決方法
IMP-00017: following statement failed with ORACLE error 957錯誤的解決方法
問題描述:
imp匯入資料時,報IMP-00017: following statement failed with ORACLE error 957錯誤。
如下所示:
IMP-00017: following statement failed with ORACLE error 957:
"CREATE FORCE VIEW "BAOPAY"."V_TMP" ("TIME","RS_ID""
","SJQB","SALE8","????","????","???","ALIPAYWAP","??????","????","?????","??"
"?") AS "
"select time ,max(RS_ID) as RS_ID"
",nvl(sum(decode(to_char(channel_id),'????????',u_sum)),0)"SJQB""
",nvl(sum(decode(to_char(channel_id),'??',u_sum)),0)"SALE8""
",nvl(sum(decode(to_char(channel_id),'????',u_sum)),0)"????""
",nvl(sum(decode(to_char(channel_id),'????',u_sum)),0)"????""
",nvl(sum(decode(to_char(channel_id),'???',u_sum)),0)"???""
",nvl(sum(decode(to_char(channel_id),'???wap',u_sum)),0)"ALIPAYWAP""
",nvl(sum(decode(to_char(channel_id),'??????',u_sum)),0)"??????""
",nvl(sum(decode(to_char(channel_id),'????',u_sum)),0)"????""
",nvl(sum(decode(to_char(channel_id),'?????',u_sum)),0)"?????""
",nvl(sum(decode(to_char(channel_id),'???',u_sum)),0)"???""
"from v_bp_user_reserve_sum group by time order by 1,2"
IMP-00003: ORACLE error 957 encountered
ORA-00957: duplicate column name
About to enable constraints...
Import terminated successfully with warnings.
問題分析:
1、建立檢視時,出現中文字元列名導致IMP時報錯;
解決方法:
方法一、透過PL/SQL工具,分別手工建立報錯的檢視;
方法二、透過PL/SQL工具,分別手工建立報錯的檢視,並將中文列名修改為英文名稱顯示,避免下次匯入資料時報同樣的錯誤;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14663377/viewspace-1035926/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- FreeBSD系統下zfs: failed with error 6錯誤的解決方法AIError
- git push出現unpack failed: error Missing tree錯誤的解決方法GitAIError
- 解決錯誤:ASP.NET Error: Failed to access IIS metabaseASP.NETErrorAI
- Invalid bound statement (not found)錯誤解決
- HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法HTTPServerError
- Datastore error in 'dirbdb'錯誤解決ASTError
- Resolving failed: Temporary failure in name resolution 錯誤解決方法AI
- 【Oracle】ORA-00054 錯誤解決方法Oracle
- PHP curl error 60 錯誤解決PHPError
- Job for mysqld.service failed because the control process exited with error code錯誤解決MySqlAIError
- ORACLE匯入遇到ORACLE錯誤959解決方法Oracle
- oracle ORA-12899錯誤的解決方法Oracle
- Oracle 常見的錯誤問題及解決方法Oracle
- Failed to run the WC DB work queue associated with 錯誤的解決AI
- 【ERROR】Oracle列印錯誤程式碼解釋ErrorOracle
- win10系統開機提示critical service failed錯誤的解決方法Win10AI
- 切換分支 error: Your local changes tby checkout: 錯誤解決方法Error
- NetworkError: Failed to execute 'send' on 'XMLHttpRequest': Failed to load xxxx錯誤解決方法ErrorAIXMLHTTP
- undefined reference to錯誤的解決方法Undefined
- PHP錯誤“Thisfilehasexpired”的解決方法PHP
- Oracle 資料庫連線錯誤解決方法Oracle資料庫
- INSTALL_FAILED_NO_MATCHING_ABIS錯誤解決AI
- IDEA啟動時報Failed to create JVM錯誤的解決IdeaAIJVM
- HTTP 錯誤 500.21 - Internal Server Error 解決方案HTTPServerError
- TNS-04414 file error 錯誤解決Error
- SSL錯誤ssl connect error 35的解決方案Error
- 記一次OPatch failed with error code 73錯誤AIError
- Win10系統玩遊戲提示runtime error錯誤的解決方法Win10遊戲Error
- Oracle資料庫配置錯誤資訊解決方法(轉)Oracle資料庫
- 錯誤Namenodeisinsafemode的解決方法
- git pull遇到錯誤:error: Your local changes to the following files would be overwritten by merge:GitError
- Oracle EBS 打中文補丁錯誤 的一個解決方法Oracle
- vsftpd 錯誤:530 and 500 錯誤解決方法FTP
- [Modules/zlibmodule.o] Error 1錯誤解決IBMError
- Error:ORA-01033:ORACLE initialization or shutdown in progress錯誤解決(轉)ErrorOracle
- ERROR L107: ADDRESS SPACE OVERFLOW keil錯誤的解決方法Error
- smplx 的 libGL error: MESA-LOADER: failed to open swrast 的解決方法ErrorAIAST
- mysqldump error1066 錯誤的解決辦法MySqlError