012013
 

Oracle imp/exp导入导出文件的编码

环境:
源数据库:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
源系统:Window 2003 R2
目标数据库:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
目标系统:CentOS release 6.4 (Final)

需求:将源数据库中HTIMS用户所有数据导入到目标数据库中。
实现方式:
在源系统上执行EXP HTIMS/HTIMS@QCJK FULL=Y FILE=HTIMS_2013_08_01.dmp LOG=IMP.LOG
在目标系统上执行imp HTIMS/HTIMS@DB11G FULL=Y FILE=HTIMS_2013_08_01.dmp LOG=IMP.LOG

问题:导入时因编码问题中文字段名编程了?
IMP-00017: following statement failed with ORACLE error 957:
“CREATE FORCE VIEW “HTIMS”.”VIEW_BASE_OFFICE” (“??”
“”,”??”,”GEOMETRY”,”????”,”?????”,”???”,”?????”,”??”,”ORG”,”????”) AS ”
“SELECT Bc.Office_Id,”
” Bc.Office_Code,”
” BC.GEOMETRY,”
” ‘???’,”
” bc.OFFICE_NAME,”
” bc.LINKMAN,”
” bc.LINKPHONE,”
” bc.BRIEF,”
” SO.CODE,”
” SO.NAME”
” FROM base_office bc ,”
” sys_org so”
” WHERE bc.sys_org_id = so.sys_org_id”
” AND SO.DEL_FLG = 0″
” AND bc.geometry IS NOT NULL”
” AND BC.DEL_FLG = ’0′”
IMP-00003: ORACLE error 957 encountered
ORA-00957: duplicate column name

继续阅读 »