IMP-00017: following statement failed with ORACLE error 957錯誤的解決方法

xingfei80發表於2010-08-03
原文網址 : http://blog.itpub.net/14663377/viewspace-1035926/
AIOracleError

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.

[@more@]

問題分析：
1、建立檢視時，出現中文字元列名導致IMP時報錯；

解決方法：
方法一、透過PL/SQL工具，分別手工建立報錯的檢視；
方法二、透過PL/SQL工具，分別手工建立報錯的檢視，並將中文列名修改為英文名稱顯示，避免下次匯入資料時報同樣的錯誤；

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/14663377/viewspace-1035926/，如需轉載，請註明出處，否則將追究法律責任。

相關文章