oracle报957,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工具，分别手工创建报错的视图，并将中文列名修改为英文名称显示，避免下次导入数据时报同样的错误；