日期:2014-05-16  浏览次数:20892 次

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_v