开发同事给我一个dmp文件,要导入到现在的测试rhel5上面的yisile库的zxy用户中,
我采用导入语句如下:
imp
userid=system/system@yisile file=/oracle/xzbpp.dmp fromuser=xzbpp touser=zxy log=/oracle/import_yisile_songzhun.log
(注:因为我不知是哪个用户导出这个xzbpp的dmp文件,先用imp 试导下,就知道是哪个用户导出的,马上中断掉,呵呵,然后再写真正imp的脚本),别加上full=y,哈哈
由于字符集的原因:
查看导入日志(imp),发现如下存储过程没有构建或导入成功(select count(distinct name) from user_source查存储过程总数)
IMP-00098: INTERNAL ERROR: impccr2
IMP-00098: INTERNAL ERROR: impccr2
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "PROC_FX_OPERATIONSUM" COMPILE REUSE SETTINGS TIMESTAMP '20"
"10-06-17:11:06:03'"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object PROC_FX_OPERATIONSUM does not exist
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "PROC_FX_PRESSSUM" COMPILE REUSE SETTINGS TIMESTAMP '2010-0"
"6-17:11:04:26'"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object PROC_FX_PRESSSUM does not exist
About to enable constraints...
Import terminated successfully with warnings.
-bash-3.2$
IMP-00098: INTERNAL ERROR: impccr2
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "PROC_FX_OPERATIONSUM" COMPILE REUSE SETTINGS TIMESTAMP '20"
"10-06-17:11:06:03'"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object PROC_FX_OPERATIONSUM does not exist
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "PROC_FX_PRESSSUM" COMPILE REUSE SETTINGS TIMESTAMP '2010-0"
"6-17:11:04:26'"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object PROC_FX_PRESSSUM does not exist
About to enable constraints...
Import terminated successfully with warnings.
-bash-3.2$
后来处理方法为:
1,设置secure crt及NLS_LANG及要导入的ORACLE数据库字符集为一致性,全是ZHS16GBK(记得:secure crt的字符集很重要,不然还是导不进存储过程,选择default)
-bash-3.2$ env|grep LANG
NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS16GBK'
NLS_LANG='SIMPLIFIED CHINESE_CHINA.ZHS16GBK'
secure crt选择默认
数据库字符集为zhs16gbk
2,数据库字符集有些复杂,还有rhel5上面的还有LANG环境变量,这又是起什么作用呢
3,可否直接修改导出的dmp文件的字符集,再次测试导入到目标数据库,看是否还有乱码或存储过程无法创建及导入的情况发生,这个也要记录blog
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-666050/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-666050/