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 := '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(,5000000000000000000000,442933065411775000000000000000"
"000000,442933065411775000000000000000000000,4429330654117750000000000000000"
"00000); SREC.NOVALS := DBMS_STATS.NUMARRAY(44293306541177500000000000000000"
"0000,442933065411775000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMAR"
"RAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"EIMS_FLOW_CONDI"
"TIONSET"','"FID"', NULL ,NULL,NULL,2,.0454545454545455,0,srec,17,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
[解决办法]
STATISTICS=NONE
倒入的时候把上面的参数追加一下看看，好像是统计信息倒入的时候出错了。
[解决办法]
