当前位置: 代码迷 >> Oracle管理 >> imp导入数据库备份文件时候,有部分报错,请教如何解决
  详细解决方案

imp导入数据库备份文件时候,有部分报错,请教如何解决

热度:23   发布时间:2016-04-24 04:26:56.0
imp导入数据库备份文件时候,有部分报错,请问怎么解决?
用如下命令,
imp ss/123@xx fromuser=ss touser=ss file=/opt/oracle/oradata/20140125.dmp
把A机器的备份文件,还原到B机器上。曾经A,B机器字符集不一样,查找网络上资料手工修改一样了。然后在Imp时候,报错内容如下:

----------------------------
following statement failed with ORACLE error 6550:
 "DECLARE  SREC DBMS_STATS.STATREC; 
BEGIN SREC.MINVAL := '0020002053165DE5516"
 "C53F80020'; SREC.MAXVAL := '9F5051498F89'; SREC.EAVS := 4; SREC.CHVALS := D"
 "BMS_STATS.CHARARRAY(utl_raw.cast_to_varchar2('0020002053165DE5516C53F80020'"
 "),utl_raw.cast_to_varchar2('0020002077F36CB35B505E02540952295EFA67506709965"
 "0516C53F8'),utl_raw.cast_to_varchar2('002053165DE5516C53F8'),utl_raw.cast_t"
 "o_varchar2('002053165DE5516C53F80020'),utl_raw.cast_to_varchar2('002053165D"
 "E55382'),utl_raw.cast_to_varchar2('002053575C716C346CE5'),utl_raw.cast_to_v"
 "archar2('002059294E1A53165DE553820020'),utl_raw.cast_to_varchar2('002059294"
 "E1A70ED75350020'),utl_raw.cast_to_varchar2('002059294E1A753577F30020'),utl_"
 "raw.cast_to_varchar2('00205929667A8FB04E1A0020'),utl_raw.cast_to_varchar2('"
 "00205929667A8FB04E1A53165DE5'),utl_raw.cast_to_varchar2('0020592980FD753553"
 "82'),utl_raw.cast_to_varchar2('0020592980FD753577F3'),utl_raw.cast_to_varch"
 "ar2('0020592980FD753577F30020'),utl_raw.cast_to_varchar2('002059298FB053165"
 "DE5'),utl_raw.cast_to_varchar2('002059298FB053165DE50020'),utl_raw.cast_to_"
 "varchar2('002059298FB06C346CE5'),utl_raw.cast_to_varchar2('002059298FB06C34"
 "6CE50020'),utl_raw.cast_to_varchar2('002059298FB075355382'),utl_raw.cast_to"
 "_varchar2('002059298FB0753553820020'),utl_raw.cast_to_varchar2('002059298FB"
 "0753577F3'),utl_raw.cast_to_varchar2('002059298FB0753577F30020'),utl_raw.ca"
 "st_to_varchar2('00206C474E1A516C53F80020'),utl_raw.cast_to_varchar2('00206C"
 "4780FD516C53F80020'),utl_raw.cast_to_varchar2('002085438304523654C1'),utl_r"
 "aw.cast_to_varchar2('0020957F8FD0751F53160020'),utl_raw.cast_to_varchar2('0"
 "02096C656E278147A769662'),utl_raw.cast_to_varchar2('00209752677E6C346CE5002"
 "00020'),'N-S裇]',utl_raw.cast_to_varchar2('4E2D53D153165DE50020'),'N-V齱?
l"                                       8fg    PQlS','NLg(PTXQy裝"
 "S裓UglPQlS','OsQlS',utl_raw.cast_to_varchar2('4F737F8E516C53F80020'),'Q"
 "tN鯨',utl_raw.cast_to_varchar2('519C516B5E0800310034003956E2'),'S]錛lS'"
 ",utl_raw.cast_to_varchar2('53165DE5516C53F80020'),'S]錛lS鴘N','S]錝',utl"
 "_raw.cast_to_varchar2('53165DE5538200200020'),'SW\ql4l','SW\ql4l錝','XQeS'"
 ",'Y)NS]','Y)NS]錝',utl_raw.cast_to_varchar2('59294E1A53165DE553820020')"
 ",'Y)Np韚5',utl_raw.cast_to_varchar2('59294E1A70ED75350020'),'Y)Nu5S','Y)N"
 "u5w',utl_raw.cast_to_varchar2('59294E1A753577F30020'),'Y)Nu5w骲e9','Y)N"
 "ujR6T罳lS','Y)N?齬imA?       ',utl_raw.cast_to_varchar2('59294E1A82826C340"
 "020'),'Y)N芕釷lS鴕imA?        ','Y)N芕鈘imA?  ','Y)fz癗',utl_raw.cast_to_"
 "varchar2('5929667A8FB04E1A0020'),'Y)fz癗S]','Y)齋]',utl_raw.cast_to_va"
 "rchar2('592980FD53165DE50020'),'Y)齋]錬e9','Y)齋]鍀5w骽續K[','Y)齦4l'"
 ",'Y)齦4l錬e9','Y)齯5S',utl_raw.cast_to_varchar2('592980FD753553820020'),"
 "'Y)齯5SY''O','Y)齯5Sbe9','Y)齯5w',utl_raw.cast_to_varchar2('592980FD7"
 "53577F30020'),utl_raw.cast_to_varchar2('592980FD753577F300200020'),'Y)癝]"
 "',utl_raw.cast_to_varchar2('59298FB053165DE50020'),'Y)癝]錛l','Y)癝]録續"
 "KN-_','Y)發4l',utl_raw.cast_to_varchar2('59298FB06C346CE50020'),'Y)發4l錣"
 "''O','Y)皍5S',utl_raw.cast_to_varchar2('59298FB0753553820020'),'Y)皍5w',u"
 "tl_raw.cast_to_varchar2('59298FB0753577F30020'),'Y)皍5w骲e9','^N`郚"
 "?齡  PQlS','_ _ft4','b^N     gI[N芕鈍        PQlS','bXQK
QlS','bXQK
',"
 "utl_raw.cast_to_varchar2('627F8FD065B9FF1A0020946B6E90516C53F8'),'e皍RGV"
 "鼸rimAg       PQlS','e皍Y)^穟\rguribg/QlS',utl_raw.cast_to_varchar2('65B0758"
 "665B04EC153165DE5516C53F80020'),'e皍uN??QuV鈡,Qm^鷞Q[臸鍅
                                                             ','e皍袾"
 "b?l}fV辝6b沏?        g       P',utl_raw.cast_to_varchar2('65B077F377F370700020')"
 ",'gm]轛       y綪ㄐg  PQlS','lGN','lGNQlS',utl_raw.cast_to_varchar2('6C474E1A5"
 "16C53F80020'),'lG','lG齉lS',utl_raw.cast_to_varchar2('6C4780FD516C53F8002
"                                                 8fg   PQlS','w髄砙"
 "PSW\ql4l錝','w髄砙PY){Q^?芕釴-Y)QlS','|緇砮皐體髉p','|緇砯v縲?N','l4"
 "QlS','l4RQlS','\Ye痎SW\竝LS:l4gClcbl4e9','knlS','衭S',ut"
 "l_raw.cast_to_varchar2('957F8FD0751F53160020'),'芕鈘imA','芕鈙疧?'Rg~"
 "l4l',utl_raw.cast_to_varchar2('9752677E6C346CE50020'),'Rg~l4l錣''O','PQI"
  相关解决方案