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.

[@more@]

问题分析：
1、创建视图时，出现中文字符列名导致IMP时报错；

解决方法：
方法一、通过PL/SQL工具，分别手工创建报错的视图；
方法二、通过PL/SQL工具，分别手工创建报错的视图，并将中文列名修改为英文名称显示，避免下次导入数据时报同样的错误；

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14663377/viewspace-1035926/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14663377/viewspace-1035926/