ORACLE IMP-00017: following statement failed with ORACLE error 6550

最新推荐文章于 2023-02-13 10:17:57 发布
大海深处的星星
最新推荐文章于 2023-02-13 10:17:57 发布
阅读量2.5k
点赞数 1
分类专栏： oracle
oracle 专栏收录该内容
37 篇文章 2 订阅
订阅专栏
转载自：https://blog.csdn.net/xcy1193068639/article/details/79257557
今个在导入数据表的时候遇到了问题，导入没有被中断。
报错贴出来：
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set  
. importing GJNBS's objects into PXNBS  
. . importing table           <span class="space" style="white-space:pre;display:inline-block;text-indent:2em;line-height:inherit;">   </span>"LAYOUT"          4 rows imported  
. . importing table                   "ITYPE"          8 rows imported  
. . importing table                   "T_TASKPUBLISH"       4832 rows imported  
. . importing table                   "T_FORMTASK"         35 rows imported  
. . importing table                   "INDICATOR_1"        975 rows imported  
. . importing table                   "CODE1"       9241 rows imported  
. . importing table                   "CATEGORY"         98 rows imported  
IMP-00017: following statement failed with ORACLE error 6550:  
 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4F4F6237519C6C115DE"  
 "5'; SREC.MAXVAL := '900080158FD86797FF088349FF0976D16D4B8C0367E565B96848'; "  
 "SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY('OOb7Ql]?'OOb7e6e/N"  
 "um;r?Q?g?hH',utl_raw.cast_to_varchar2('4F4F62376536652F4E0E751F6D3B72"  
 "B651B58C0367E595EE5377004D'),utl_raw.cast_to_varchar2('4F4F62376536652F4E0E"  
 "751F6D3B72B651B58C0367E595EE5377FF0800410031'),utl_raw.cast_to_varchar2('4F"  
 "4F62376536652F4E0E751F6D3B72B651B58C0367E595EE5377FF0800410032'),utl_raw.ca"  
 "st_to_varchar2('4F4F62376536652F4E0E751F6D3B72B651B58C0367E595EE5377FF08004"  
 "2FF09'),utl_raw.cast_to_varchar2('4F4F62376536652F4E0E751F6D3B72B651B58C036"  
 "7E595EE5377FF080043FF09'),utl_raw.cast_to_varchar2('4F4F62376536652F4E0E751"  
 "F6D3B72B651B58C0367E595EE5377FF080045FF09'),utl_raw.cast_to_varchar2('4F4F6"  
 "2376536652F4E0E751F6D3B72B651B58C0367E595EE5377FF080046FF09'),utl_raw.cast_"  
 "to_varchar2('4F4F62376536652F4E0E751F6D3B72B651B58C0367E595EE5377FF080047FF"  
 "09'),utl_raw.cast_to_varchar2('4F4F62376536652F4E0E751F6D3B72B651B58C0367E5"  
 "95EE5377FF08004DFF09'),utl_raw.cast_to_varchar2('519C623756FA5B9A8D444EA762"  
 "958D4460C551B500287EFC54085E7462A50029'),utl_raw.cast_to_varchar2('519C6237"  
 "56FA5B9A8D444EA762958D4460C551B55B6362A500287EFC54085B9A'),'Qb7V??N§b"  
 "D`??[cb?h','Qb7V??N§bD`??^tb?h','Qb7V??g?hH',utl_raw.cast_t"  
 "o_varchar2('519C62375EFA623F62958D4460C551B5002857FA5C425E7462A50029000A'),"  
 "utl_raw.cast_to_varchar2('519C62375EFA623F62958D4460C551B500287EFC54085E746"  
 "2A50029'),'Qb7^??D`??[cb?h','Qb7^??D`??^tb?h',utl_raw.cast_to"  
 "_varchar2('519C67518D2B56F076D16D4B8C0367E595EE53770048'),utl_raw.cast_to_v"  
 "archar2('519C67518D2B56F076D16D4B8C0367E595EE53770050'),utl_raw.cast_to_var"  
 "char2('519C67518D2B56F076D16D4B8C0367E595EE537700500032'),utl_raw.cast_to_v"  
 "archar2('519C67518D2B56F076D16D4B8C0367E595EE53770053'),utl_raw.cast_to_var"  
 "char2('519C67518D2B56F076D16D4B8C0367E595EE53770056'),'Ql]?lS?  
                                                                 R¨`"  
 "vЭKg?hH','Ql]?lS?  
                     R¨`vЭKg?Sw','Ql]?mKg?hH','V  
 "gQ+V??Kg?hH',utl_raw.cast_to_varchar2('5B635EA676D16D4B8C0367E595EE"  
 "53770028004E00310029'),utl_raw.cast_to_varchar2('5B635EA676D16D4B8C0367E595"  
 "EE53770028004E00370029'),utl_raw.cast_to_varchar2('5E745EA676D16D4B8C0367E5"  
 "95EE53770028004E00320029'),utl_raw.cast_to_varchar2('5E745EA676D16D4B8C0367"  
 "E595EE53770028004E00330029'),utl_raw.cast_to_varchar2('5E745EA676D16D4B8C03"  
 "67E595EE53770028004E00340029'),utl_raw.cast_to_varchar2('5E745EA676D16D4B8C"  
 "0367E595EE53770028004E00350029'),utl_raw.cast_to_varchar2('5E745EA676D16D4B"  
 "8C0367E595EE53770028004E00360029'),utl_raw.cast_to_varchar2('6536652F8C0367"  
 "E5002D4E0A6D775E0252065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5"  
 "002D4E915357770152065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E500"  
 "2D5185849953E481EA6CBB533A52065E0253BF'),utl_raw.cast_to_varchar2('6536652F"  
 "8C0367E5002D52067701'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D53174E"  
 "AC5E0252065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D54096797"  
 "770152065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D56DB5DDD77"  
 "0152065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D59296D255E02"  
 "52065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D5B81590F56DE65"  
 "CF81EA6CBB533A52065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D"  
 "5B895FBD770152065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D5C"  
 "714E1C770152065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D5C71"  
 "897F770152065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D5E7F4E"  
 "1C770152065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367E5002D5E7F897F"  
 "58EE65CF81EA6CBB533A52065E0253BF'),utl_raw.cast_to_varchar2('6536652F8C0367"  
 "E5002D65B07586751F4EA75EFA8BBE517556E252065E0253BF'),utl_raw.cast_to_varcha"  
 "r2('6536652F8C0367E5002D65B075867EF4543E5C1481EA6CBB533A52065E0253BF'),utl_"  
 "raw.cast_to_varchar2('6536652F8C0367E5002D6C5F82CF770152065E0253BF'),utl_ra"  
 "w.cast_to_varchar2('6536652F8C0367E5002D6C5F897F770152065E0253BF'),utl_raw."  
 "cast_to_varchar2('6536652F8C0367E5002D6CB35317770152065E0253BF'),utl_raw.ca"  
 "st_to_varchar2('6536652F8C0367E5002D6CB35357770152065E0253BF'),utl_raw.cast"  
 "_to_varchar2('6536652F8C0367E5002D6D596C5F770152065E0253BF'),utl_raw.cast_t"  
 "o_varchar2('6536652F8C0367E5002D6D775357770152065E0253BF'),utl_raw.cast_to_"  
 "varchar2('6536652F8C0367E5002D6E565317770152065E0253BF'),utl_raw.cast_to_va"  
 "rchar2('6536652F8C0367E5002D6E565357770152065E0253BF'),utl_raw.cast_to_varc"  
 "har2('6536652F8C0367E5002D75188083770152065E0253BF'),utl_raw.cast_to_varcha"  
 "r2('6536652F8C0367E5002D798F5EFA770152065E0253BF'),utl_raw.cast_to_varchar2"  
 "('6536652F8C0367E5002D897F85CF81EA6CBB533A52065E0253BF'),utl_raw.cast_to_va"  
 "rchar2('6536652F8C0367E5002D8D355DDE770152065E0253BF'),utl_raw.cast_to_varc"  
 "har2('6536652F8C0367E5002D8FBD5B81770152065E0253BF'),utl_raw.cast_to_varcha"  
 "r2('6536652F8C0367E5002D91CD5E865E0252065E0253BF'),utl_raw.cast_to_varchar2"  
 "('6536652F8C0367E5002D9655897F770152065E0253BF'),utl_raw.cast_to_varchar2('"  
 "6536652F8C0367E5002D97526D77770152065E0253BF'),utl_raw.cast_to_varchar2('65"  
 "36652F8C0367E5002D9ED19F996C5F770152065E0253BF'),'h7g,R6^?','~??R6^?',utl_"  
 "raw.cast_to_varchar2('7EFC54085B9A62A588685F0F002D002E5C456C116D888D39652F5"  
 "1FA'),utl_raw.cast_to_varchar2('7EFC54085B9A62A588685F0F002D5C456C1153EF652"  
 "F914D65365165'),utl_raw.cast_to_varchar2('7EFC54085B9A62A588685F0F002D8C036"  
 "7E56237548C8C0367E54EBA53E357FA'),utl_raw.cast_to_varchar2('7EFC54085E7462A"  
 "588685F0F002D4F4F623F548C801075286D888D3954C162E5'),utl_raw.cast_to_varchar"  
 "2('7EFC54085E7462A588685F0F002D5C456C1153EF652F914D65365165'),utl_raw.cast_"  
 "to_varchar2('7EFC54085E7462A588685F0F002D5C456C115BB65EAD80FD6E906D888D3965"  
 "70'),utl_raw.cast_to_varchar2('7EFC54085E7462A588685F0F002D5C456C115BB65EAD"  
 "98DF54C16D888D396570'),utl_raw.cast_to_varchar2('7EFC54085E7462A588685F0F00"  
 "2D5C456C116D888D39652F51FA'),utl_raw.cast_to_varchar2('7EFC54085E7462A58868"  
 "5F0F002D793E533A57FA78408BBE65BD548C5C456C11'),utl_raw.cast_to_varchar2('7E"  
 "FC54085E7462A588685F0F002D8C0367E56237548C8C0367E54EBA53E357FA'),'&u','&"  
 "uf??h',utl_raw.cast_to_varchar2('900080158FD86797FF088349FF0953BF57FA672"  
 "C60C551B57EDF8BA18868'),utl_raw.cast_to_varchar2('900080158FD86797FF088349F"  
 "F095B8C621060C551B58C0367E58868'),utl_raw.cast_to_varchar2('900080158FD8679"  
 "7FF088349FF0976D16D4B8C0367E565B96848')); SREC.NOVALS := DBMS_STATS.NUMARRA"  
 "Y(411801543663204000000000000000000000,411801543686900000000000000000000000"  
 ",411801543686900000000000000000000000,411801543686900000000000000000000000,"  
 "411801543686900000000000000000000000,411801543686900000000000000000000000,4"  
 "11801543686900000000000000000000000,411801543686900000000000000000000000,41"  
 "1801543686900000000000000000000000,411801543686900000000000000000000000,411"  
 "801543686900000000000000000000000,423747882926243000000000000000000000,4237"  
 "47882926243000000000000000000000,423747882926243000000000000000000000,42374"  
 "7882926243000000000000000000000,423747882926243000000000000000000000,423747"  
 "882935914000000000000000000000,423747882935914000000000000000000000,4237478"  
 "82935914000000000000000000000,423747882935914000000000000000000000,42374828"  
 "7179179000000000000000000000,423748287179179000000000000000000000,423748287"  
 "179179000000000000000000000,423748287179179000000000000000000000,4237482871"  
 "79179000000000000000000000,423748663455801000000000000000000000,42374866345"  
 "5801000000000000000000000,423748663455801000000000000000000000,451676245651"  
 "441000000000000000000000,474514471642861000000000000000000000,4745144716428"  
 "61000000000000000000000,490436163181728000000000000000000000,49043616318172"  
 "8000000000000000000000,490436163181728000000000000000000000,490436163181728"  
 "000000000000000000000,490436163181728000000000000000000000,5255252495900900"  
 "00000000000000000000,525525249590090000000000000000000000,52552524959009000"  
 "0000000000000000000,525525249590090000000000000000000000,525525249590090000"  
 "000000000000000000,525525249590090000000000000000000000,5255252495900900000"  
 "00000000000000000,525525249590090000000000000000000000,52552524959009000000"  
 "0000000000000000,525525249590090000000000000000000000,525525249590090000000"  
 "000000000000000,525525249590090000000000000000000000,5255252495900900000000"  
 "00000000000000,525525249590090000000000000000000000,52552524959009000000000"  
 "0000000000000,525525249590090000000000000000000000,525525249590090000000000"  
 "000000000000,525525249590090000000000000000000000,5255252495900900000000000"  
 "00000000000,525525249590090000000000000000000000,52552524959009000000000000"  
 "0000000000,525525249590090000000000000000000000,525525249590090000000000000"  
 "000000000,525525249590090000000000000000000000,5255252495900900000000000000"  
 "00000000,525525249590090000000000000000000000,52552524959009000000000000000"  
 "0000000,525525249590090000000000000000000000,525525249590090000000000000000"  
 "000000,525525249590090000000000000000000000,5255252495900900000000000000000"  
 "00000,525525249590090000000000000000000000,52552524959009000000000000000000"  
 "0000,541122580033291000000000000000000000,658763444158067000000000000000000"  
 "000,659347229147781000000000000000000000,6593472291477810000000000000000000"  
 "00,659347229147781000000000000000000000,65934722915122800000000000000000000"  
 "0,659347229151228000000000000000000000,659347229151228000000000000000000000"  
 ",659347229151228000000000000000000000,659347229151228000000000000000000000,"  
 "659347229151228000000000000000000000,659347229151228000000000000000000000,7"  
 "32896667508798000000000000000000000,732896667633262000000000000000000000,74"  
 "7700895506901000000000000000000000,747700895506901000000000000000000000,747"  
 "700895506901000000000000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(1,2,"  
 "3,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,24,25,26,27,28,39,40,41,4"  
 "2,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,6"  
 "7,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,9"  
 "2,93,94,95,96,97,98); SREC.EPC := 86; DBMS_STATS.SET_COLUMN_STATS(NULL,'"DS"  
 "FA_CATEGORY"','"NAME"', NULL ,NULL,NULL,95,.00510204081632653,0,srec,28,6);"  
 " END;"  
IMP-00003: ORACLE error 6550 encountered  
ORA-06550: line 1, column 217:  
PLS-00103: Encountered the symbol "OOB7E6E" when expecting one of the following:  

   ) , * & = - + < / > at in is mod remainder not rem =>  
   <an exponent (**)> <> or != or ~= >= <= <> and or like like2  
   like4 likec as between from using || multiset member