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

oracle imp 报错 6550 --在线等高手.谢谢了,急啊!!!
情况:从9i版本exp导出数据.
  导入10g版本的时候就报如下错误.(用imp导入)
导入语句:
imp unicomdef/unicomdef file=D:\UNICOM\2111111111111111111111.dmp commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes log=E:\log\20110117log.log



IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
 "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '554E49434F4D5F43545"
 "95A53584D'; SREC.MAXVAL := '554E49434F4D5F4C4F43414C425553494E455353'; SREC"
 ".EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(DECLARE SREC DBMS_STATS.ST"
 "ATREC; BEGIN SREC.MINVAL := '554E49434F4D5F4354595A53584D'; SREC.MAXVAL := "
 "'554E49434F4D5F4C4F43414C425553494E455353'; SREC.EAVS := 4; SREC.CHVALS := "
 "DBMS_STATS.CHARARRAY(,); SREC.NOVALS := DBMS_STATS.NUMARRAY(442933065411775"
 "000000000000000000000,442933065411775000000000000000000000); SREC.BKVALS :="
 " DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,"
 "'"EIMS_FLOW_CONDITION"','"FID"', NULL ,NULL,NULL,2,.125,0,srec,18,2); END;"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 199 列: 
PLS-00103: 出现符号 "DECLARE"在需要下列之一时:
 ( ) - + case mod new
  not null others <an identifier>
  <a double-quoted delimited-identifier> <a bind variable>
  table avg count current exists max min prior sql stddev sum
  variance execute multiset the both leading trailing forall
  merge year month DAY_ hour minute second timezone_hour
  timezone_minute timezone_region timezone_abbr time timestamp
  interval date
  <a string literal with character set specificat
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
 "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '554E49434F4D5F43545"
 "95A53584D2E3135'; SREC.MAXVAL := '554E49434F4D5F4C4F43414C425553494E4553532"
 "E3332'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(DECLARE SREC D"
 "BMS_STATS.STATREC; BEGIN SREC.MINVAL := '554E49434F4D5F4354595A53584D2E3135"
 "'; SREC.MAXVAL := '554E49434F4D5F4C4F43414C425553494E4553532E3332'; SREC.EA"
 "VS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(,); SREC.NOVALS := DBMS_STATS."
 "NUMARRAY(442933065411775000000000000000000000,44293306541177500000000000000"
 "0000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
 "S.SET_COLUMN_STATS(NULL,'"EIMS_FLOW_CONDITION"','"TID"', NULL ,NULL,NULL,2,"
 ".125,0,srec,21,2); END;"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 211 列: 
PLS-00103: 出现符号 "DECLARE"在需要下列之一时:
 ( ) - + case mod new
  not null others <an identifier>
  <a double-quoted delimited-identifier> <a bind variable>
  table avg count current exists max min prior sql stddev sum
  variance execute multiset the both leading trailing forall
  merge year month DAY_ hour minute second timezone_hour
  timezone_minute timezone_region timezone_abbr time timestamp
  interval date
  <a string literal with character set specificat
. . 正在导入表 "EIMS_FLOW_CONDITIONSET"导入了 11 行
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
 "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '554E49434F4D5F43545"
 "95A53584D'; SREC.MAXVAL := '554E49434F4D5F4C4F