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