statistics 异常

imp gloryou_jngbs/gloryou~!@saasdb file=e:\xx.dmp full=y

 

报如下

由常规路径由 EXPORT:V11.02.00 创建的导出文件
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 GLORYOU_JNGBS 的对象导入到 GLORYOU_JNGBS
. 正在将 GLORYOU_JNGBS 的对象导入到 GLORYOU_JNGBS
. . 正在导入表             "INDEX"导入了          78 行
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '002F002F00400068006"
 "C005F0030003000300031003A002053D15E0356FE7247'; SREC.MAXVAL := '98769876987"
 "6'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cast_to_var"
 "char2('002F002F00400068006C005F0030003000300031003A002053D15E0356FE7247'),u"
 "tl_raw.cast_to_varchar2('002F002F00400068006C005F00300031003A0020002F002F00"
 "400068006C005F'),utl_raw.cast_to_varchar2('002F002F00400068006C005F00300031"
 "003A002053D15E0356FE7247'),utl_raw.cast_to_varchar2('002F002F00400068006C00"
 "5F00300031003A002053D15E0356FE724700640073'),utl_raw.cast_to_varchar2('0034"
 "003400340034'),utl_raw.cast_to_varchar2('003500350035003500350035'),utl_raw"
 ".cast_to_varchar2('003C0069006D00670020007300720063003D0022002F00750075006C"
 "00610072'),utl_raw.cast_to_varchar2('00400068006C005F00300032003A0068006A00"
 "68006A00680068003300340034'),utl_raw.cast_to_varchar2('00640066006700640066"
 "00660066006600660066006600660066006600660066'),utl_raw.cast_to_varchar2('00"
 "6500650065'),utl_raw.cast_to_varchar2('007300640066007300640066007300640066"
 "'),'N蔣)Y)lN
?','RN玍G','R^鷭輼?,'S裗VG','榲榲榲'); SREC.NOVALS :"
 "= DBMS_STATS.NUMARRAY(953287797469329000000000000000000,9532877974693290000"
 "00000000000000,953287797469329000000000000000000,95328779746932900000000000"
 "0000000,1054701392855960000000000000000000,10749841119493500000000000000000"
 "00,1216977072659880000000000000000000,1298106401584750000000000000000000,20"
 "28272528322580000000000000000000,2048554628431770000000000000000000,2332508"
 "053402610000000000000000000,409103265808793000000000000000000000,4258962696"
 "81260000000000000000000000,426323492446770000000000000000000000,43520711134"
 "6454000000000000000000000,791634526214772000000000000000000000); SREC.BKVAL"
 "S := DBMS_STATS.NUMARRAY(8,9,10,11,13,16,18,19,21,22,25,26,29,34,36,38); SR"
 "EC.EPC := 16; DBMS_STATS.SET_COLUMN_STATS(NULL,'"INDEX"','"NOTE"
 ""', NULL ,NULL,NULL,17,.0131578947368421,2,srec,23,6); END;"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 28 列:
PLS-00103: 出现符号 "S裗"在需要下列之一时：
 ) , * & = - + < / > at in
   is mod remainder not rem => <an exponent (**)> <> or != or ~=
   >= <= <> and or like like2 like4 likec between || multiset
   member submultiset

 

找了相关资料，报的是统计信息的问题

 

 imp的时候，statistics=none 就可以了