oracle 导入数据statistics

最新推荐文章于 2023-10-07 14:45:46 发布

farmering

最新推荐文章于 2023-10-07 14:45:46 发布

阅读量6.9k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/sunchen2012/article/details/51952599

版权

数据库专栏收录该内容

6 篇文章 1 订阅

订阅专栏

oracle 11g导入时候出现以下错误，可以试一试statistics=none,先不导入统计信息，等数据导入完成后，空闲时间再重新生成统计信息

IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:

"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '0020002000200020002"
"050A86C147F50'; SREC.MAXVAL := 'FF0891CD5F0FFF09753552A8846B82A6'; SREC.EAV"

"S := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cast_to_varchar2('00200"

IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 824 列:
PLS-00103: 出现符号 "N宬"在需要下列之一时：
) , * & = - + < / > at in
is mod remainder not rem => <an exponent (**)> <> or != or ~=
>= <= <> and or like like2 like4 likec between || multiset
member submultiset
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '00090009'; SREC.MAX"
"VAL := 'FF1353F7697C003153555143'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STAT"
"S.CHARARRAY(utl_raw.cast_to_varchar2('00090009'),utl_raw.cast_to_varchar2('"
"0023003370896E234ED3987690E8'),utl_raw.cast_to_varchar2('00307C735C424E1C4F"
"A77B2C4E0953F0538B7F29673A'),utl_raw.cast_to_varchar2('00310023697C4E095355"
"5143'),utl_raw.cast_to_varchar2('003100300023697C897F53555143'),utl_raw.cas"
"t_to_varchar2('0031003300230042697C004600540032'),utl_raw.cast_to_varchar2("
"'00310035003800305E2694A253820032002352A070ED70898DE8'),utl_raw.cast_to_var"
"char2('003100390023697C003353555143'),utl_raw.cast_to_varchar2('00320023697"
"C003253555143897F68AF'),utl_raw.cast_to_varchar2('003200300023697C003253555"

IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 2 行, 第 62 列:
PLS-00114: 标识符 'C65B991D1684256ED00360023697C4' 太长
ORA-06550: 第 2 行, 第 59 列:
PLS-00103: 出现符号 "4E1"在需要下列之一时：
) , * & = - + < / > at in
is mod remainder not rem => <an exponent (**)> <> or != or ~=
>= <= <> and or like like2 like4 likec between || multiset
member submultiset
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '0020'; SREC.MAXVAL "
":= '9F509C8177F3531668C04FEE516C53F8'; SREC.EAVS := 4; SREC.CHVALS := DBMS_"
"STATS.CHARARRAY(utl_raw.cast_to_varchar2('0020'),utl_raw.cast_to_varchar2('"
"002D'),utl_raw.cast_to_varchar2('005C'),'N"
"mwN 凂u5h痝朠QlS鳱4l俁QlS?,'N"
"mwN 凂u5h痝朠QlS鳿qNRQlS?,utl_raw.cast_to_varchar2('4E0A6D774E1C65B9753"
"568AF9500552E5B8988C5516C53F8'),utl_raw.cast_to_varchar2('4E0A6D774E1C65B97"
"53568AF9500552E5B8988C567099650516C53F8'),'N"
"mwN殐駏5h痌鍅 g 朠QlS?,'N"
"mwN殐駏5h痝朠QlS?,'N"