ORALCE版本11.2.0
我在客户端用命令:exp user/psw@命名空间 file=d:/.dmp ful=n导出,没问题
导入:imp user/psw@命名空间 file=d:/.dmp full=y,出现6550错误,请高手指教。oracle用的是相同版本错误提示:
警告: 这些对象由 SBGL 导出, 而不是当前用户已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 SBGL 的对象导入到 SBGLTEST
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '00320034005675356E9"
"0'; SREC.MAXVAL := '9891738791C796C66A215757FF08003100370034003600530043002"
"D00430054'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cas"
"t_to_varchar2('00320034005675356E90'),utl_raw.cast_to_varchar2('00430050005"
"5590474065668'),utl_raw.cast_to_varchar2('004E0065006D0061003463A752367BB1'"
"),utl_raw.cast_to_varchar2('0053004C0043003500300030673A67B6'),'\廸c6d蚈"
"\{?,'\廸杁\|麀?,'g:g秛5n?,utl_raw.cast_to_varchar2('6A2162DF91CF8F9351"
"656A21FF080031003700340036002D004E00490038FF09'),utl_raw.cast_to_varchar2('"
"6A2162DF91CF8F9351658F9351FA6A215757FF080031003700340036002D004E'),'鹓','"
"圠峱u5g:','夋dx\O',utl_raw.cast_to_varchar2('9891738791C796C66A215757FF0800"
"3100370034003600530043002D00430054')); SREC.NOVALS := DBMS_STATS.NUMARRAY(1"
"014136573811380000000000000000000,1358946202648490000000000000000000,158205"
"9207585570000000000000000000,1683463518280240000000000000000000,47800690844"
"4443000000000000000000000,478006908505782000000000000000000000,535991173154"
"807000000000000000000000,551060620072970000000000000000000000,5510606200729"
"70000000000000000000000,664520785649775000000000000000000000,70770504186554"
"6000000000000000000000,716017583894158000000000000000000000,792179225085226"
"000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(4,8,24,31,52,59,"
"62,71,80,86,91,103,112); SREC.EPC := 13; DBMS_STATS.SET_COLUMN_STATS(NULL,'"
""EMS_WEB_STANDARD_INSPECTION"','"I_POSITION"', NULL ,NULL,NULL,13,.00446428"
"571428571,0,srec,19,6); END;"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 457 列:
PLS-00103: 出现符号 "\"在需要下列之一时:
) , * & = - + < / > 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 := '0031003200220020005"
"3005600470041002089E664785C4F'; SREC.MAXVAL := '9AD8538B8F6F8D7767DC'; SREC"
".EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cast_to_varchar2('0"
....
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 1166 列:
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 := '0041004200350030003"
"0003063A752367CFB7EDF'; SREC.MAXVAL := '9AD8538B8F8A78E8673A621059574EEA886"
"8'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cast_to_var"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 887 列:
PLS-00103: 出现符号 "N陥H"在需要下列之一时:
) , * & = - + < / > 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 := '003100234E2D7834673"
"A004100530052002D00430042005453555143'; SREC.MAXVAL := 'FF1870B96A2162DF91C"
"F8F9351FA6A2157570031003700350036002D004F0046'; SREC.EAVS := 4; SREC.CHVALS"
" := DBMS_STATS.CHARARRAY(utl_raw.cast_to_varchar2('003100234E2D7834673A004C"
.........6550oracle
我在客户端用命令:exp user/psw@命名空间 file=d:/.dmp ful=n导出,没问题
导入:imp user/psw@命名空间 file=d:/.dmp full=y,出现6550错误,请高手指教。oracle用的是相同版本错误提示:
警告: 这些对象由 SBGL 导出, 而不是当前用户已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
. 正在将 SBGL 的对象导入到 SBGLTEST
IMP-00017: 由于 ORACLE 错误 6550, 以下语句失败:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '00320034005675356E9"
"0'; SREC.MAXVAL := '9891738791C796C66A215757FF08003100370034003600530043002"
"D00430054'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cas"
"t_to_varchar2('00320034005675356E90'),utl_raw.cast_to_varchar2('00430050005"
"5590474065668'),utl_raw.cast_to_varchar2('004E0065006D0061003463A752367BB1'"
"),utl_raw.cast_to_varchar2('0053004C0043003500300030673A67B6'),'\廸c6d蚈"
"\{?,'\廸杁\|麀?,'g:g秛5n?,utl_raw.cast_to_varchar2('6A2162DF91CF8F9351"
"656A21FF080031003700340036002D004E00490038FF09'),utl_raw.cast_to_varchar2('"
"6A2162DF91CF8F9351658F9351FA6A215757FF080031003700340036002D004E'),'鹓','"
"圠峱u5g:','夋dx\O',utl_raw.cast_to_varchar2('9891738791C796C66A215757FF0800"
"3100370034003600530043002D00430054')); SREC.NOVALS := DBMS_STATS.NUMARRAY(1"
"014136573811380000000000000000000,1358946202648490000000000000000000,158205"
"9207585570000000000000000000,1683463518280240000000000000000000,47800690844"
"4443000000000000000000000,478006908505782000000000000000000000,535991173154"
"807000000000000000000000,551060620072970000000000000000000000,5510606200729"
"70000000000000000000000,664520785649775000000000000000000000,70770504186554"
"6000000000000000000000,716017583894158000000000000000000000,792179225085226"
"000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(4,8,24,31,52,59,"
"62,71,80,86,91,103,112); SREC.EPC := 13; DBMS_STATS.SET_COLUMN_STATS(NULL,'"
""EMS_WEB_STANDARD_INSPECTION"','"I_POSITION"', NULL ,NULL,NULL,13,.00446428"
"571428571,0,srec,19,6); END;"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 457 列:
PLS-00103: 出现符号 "\"在需要下列之一时:
) , * & = - + < / > 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 := '0031003200220020005"
"3005600470041002089E664785C4F'; SREC.MAXVAL := '9AD8538B8F6F8D7767DC'; SREC"
".EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cast_to_varchar2('0"
....
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 1166 列:
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 := '0041004200350030003"
"0003063A752367CFB7EDF'; SREC.MAXVAL := '9AD8538B8F8A78E8673A621059574EEA886"
"8'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cast_to_var"
IMP-00003: 遇到 ORACLE 错误 6550
ORA-06550: 第 1 行, 第 887 列:
PLS-00103: 出现符号 "N陥H"在需要下列之一时:
) , * & = - + < / > 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 := '003100234E2D7834673"
"A004100530052002D00430042005453555143'; SREC.MAXVAL := 'FF1870B96A2162DF91C"
"F8F9351FA6A2157570031003700350036002D004F0046'; SREC.EAVS := 4; SREC.CHVALS"
" := DBMS_STATS.CHARARRAY(utl_raw.cast_to_varchar2('003100234E2D7834673A004C"
.........6550oracle
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货