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皍uNQuV鈡,Qm^鷞Q[臸鍅
','e皍袾"
"bl}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"
"'); SREC.NOVALS := DBMS_STATS.NUMARRAY(649047111283635000000000000000000,64"
"9047155848881000000000000000000,655619966988779000000000000000000,655619966"
"988779000000000000000000,655619966988817000000000000000000,6556400817581910"
"00000000000000000,656101197086554000000000000000000,65610119708710400000000"
"0000000000,656101197087183000000000000000000,656101226555239000000000000000"
"000,656101226555239000000000000000000,656101258605451000000000000000000,656"
"101258605451000000000000000000,656101258605451000000000000000000,6561012763"
"75087000000000000000000,656101276375087000000000000000000,65610127637555000"
(。。。。。省略一部分)
"9,230,231,232,234,235,236,239,244,246,247,248,250,252,253,254); SREC.EPC :="
" 126; DBMS_STATS.SET_COLUMN_STATS(NULL,'"WF_P_CONTRACT"','"DEMANDER_"', NUL"
"L ,NULL,NULL,366,.017971894640209,0,srec,12,6); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 3371:
PLS-00103: Encountered the symbol "Y)N" when expecting one of the following:
( - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<一个带有字符集说明的可带引号的字符串文字>
<一个可带引号的
--------------------------
从网络查询 解决办法,就是在exp或imp时加上一个参数来禁用统计信息的导出/导入: statistics=none
请问,还有没有其他的原因,看到导入结果提示里面还显示的有乱码。
但是还原后的数据库,用程序访问,没有乱码?
谢谢帮助。