oracle报错3135,oracle imp 报错 6550 -高手.多谢了,

oracle imp 报错 6550 -高手.多谢了,

热度：968   发布时间：2016-04-24 08:28:38

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

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

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

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