求助一个关于导入导出的问题

环境:源端   win server2008    ORACLE11.2.0.1.0
          目标端 win7 64位       ORACLE11.2.0.1.0
          数据库字符集都是 SIMPLIFIED CHINESE_CHINA.AL32UTF8
导出:在源端服务器注册表中修改客户端字符集
      N$P[)3A)J]T28J]BYU327)2.png
设置环境变量:NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8
导出TEST用户的全部对象:
LR@R{T8(1S%`GEE9KT5H(X6.png
导出正常,没有警告。

导入:将源端导出的文件复制到目标端,修改目标端服务器客户端字符集,环境变量。
导入时部分表不能导入。将环境变量设置为NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8后,SQL*PLUS乱码,导入日志报错如下:

杩炴帴鍒? Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
缁忕敱甯歌璺緞鐢?EXPORT:V11.02.00 鍒涘缓鐨勫鍑烘枃浠?
璀﹀憡: 杩欎簺瀵硅薄鐢?YYSMS 瀵煎嚭, 鑰屼笉鏄綋鍓嶇敤鎴?
宸茬粡瀹屾垚 AL32UTF8 瀛楃闆嗗拰 AL16UTF16 NCHAR 瀛楃闆嗕腑鐨勫鍏?
IMP-00017: 鐢变簬 ORACLE 閿欒 6550, 浠ヤ笅璇彞澶辫触:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '0031003000360035003"
"755468D85003600345B573010003500323011'; SREC.MAXVAL := '9ED1540D5355901A905"
"3'; SREC.EAVS := 4; SREC.CHVALS := DBMS_STATS.CHARARRAY(utl_raw.cast_to_var"
"char2('0031003000360035003755468D85003600345B573010003500323011'),utl_raw.c"
"ast_to_varchar2('003100300036003500379A8C8BC17801'),utl_raw.cast_to_varchar"
"2('003100300036003500397535518565B066138FB03010003100343011002D0050'),utl_r"
"aw.cast_to_varchar2('0031003000360036'),utl_raw.cast_to_varchar2('003100300"
"0360036003955468D85'),utl_raw.cast_to_varchar2('003100300036003900300030003"
"9003475354FE1884C4E1A'),utl_raw.cast_to_varchar2('0031003000360039003000310"
"0350037002D00350036003352185B8F79FB52A8'),utl_raw.cast_to_varchar2('0031003"
"0003600390030003100350037002D75354FE13010003400303011'),utl_raw.cast_to_var"
"char2('00310030003600390030003100350037002D79FB52A83010003200373011'),utl_r"
"aw.cast_to_varchar2('00310030003600390030003100350037002D8054901A3010003100"
"303011'),utl_raw.cast_to_varchar2('00310030003600390030003300320032002D7535"
"4FE13010003300383011'),utl_raw.cast_to_varchar2('00310030003600390030003300"
"320032002D79FB52A83010003200383011'),utl_raw.cast_to_varchar2('003100300036"
"00390030003300320032002D8054901A301000393011'),utl_raw.cast_to_varchar2('00"
"310030003600390030003300320032003300350035FF084E0D7528FF09'),utl_raw.cast_t"
"o_varchar2('003100300036003900300033003200337545901A79FB52A8'),utl_raw.cast"
"_to_varchar2('00310030003600390030003300380036'),utl_raw.cast_to_varchar2('"
"003100300036003900300033003800365C714E1C'),utl_raw.cast_to_varchar2('003100"
"300036003900300033003800368054901A'),utl_raw.cast_to_varchar2('003100300036"
"0039003000340033003575354FE1'),utl_raw.cast_to_varchar2('003100300036003900"
"300034003700306D596C5F4E005BA24E007B7E'),utl_raw.cast_to_varchar2('00310030"
"0036003900300034003700307535'),utl_raw.cast_to_varchar2('003100300036003900"
"3000340037003075354FE1'),utl_raw.cast_to_varchar2('003100300036003900300035"
"0030003052185B8F'),utl_raw.cast_to_varchar2('003100300036003900300035003600"
"31'),utl_raw.cast_to_varchar2('00310030003600390030003500360031002D0033002E"
"003079FB52A830100032'),utl_raw.cast_to_varchar2('00310030003600390030003500"
"360031002D8054901A3010003100313011'),utl_raw.cast_to_varchar2('003100300036"
"0039003000350036003175354FE1'),utl_raw.cast_to_varchar2('003100300036003900"
"300037003500388054901A'),utl_raw.cast_to_varchar2('003100300036003900306D4B"
"8BD5002000337F51'),utl_raw.cast_to_varchar2('003100300036003900306D4B8BD500"
"337F51'),utl_raw.cast_to_varchar2('00310030003600390039003800300031002D8054"
"901A30105B8976D13011'),utl_raw.cast_to_varchar2('00310030003600390039003800"
"3000315F694FE179FB52A8'),utl_raw.cast_to_varchar2('003100300036003900390038"
"0030003175354FE15F694FE1'),utl_raw.cast_to_varchar2('0031003000360039003900"
"380030003175354FE1884C4E1A'),utl_raw.cast_to_varchar2('00310030003600390039"
"0038003000318054901A5F694FE1'),utl_raw.cast_to_varchar2('003200330036006300"
"6D007000706D4B8BD5'),utl_raw.cast_to_varchar2('0064006400640064'),utl_raw.c"
"ast_to_varchar2('0070003177ED4FE1901A9053'),utl_raw.cast_to_varchar2('00790"
"06400310030003600390030'),utl_raw.cast_to_varchar2('4E097F51003000300036003"
"156FD9645901A90533010003100323011'),utl_raw.cast_to_varchar2('4E2D554676DB8"
"FBE003100300036003900303010590775283011'),utl_raw.cast_to_varchar2('4E2D554"
"676DB8FBE884C4E1A003100300036003900303010590775283011'),utl_raw.cast_to_var"
"char2('4E2D67176B63884C4E1A3010003500313011'),'N-旜[蘶{','N4e?,utl_raw.cas"
"t_to_varchar2('4FE18FBE00310030003600390030884C4E1A3010003100393011'),'R勢O"
"TX',utl_raw.cast_to_varchar2('536153D15F694FE130100032901A90533011'),utl_r"
"aw.cast_to_varchar2('5434521A8054901A002D00700031'),'Yu(',utl_raw.cast_to_"
"varchar2('5929522900310032003500320030'),utl_raw.cast_to_varchar2('59295229"
"00310032003500320030884C4E1A'),utl_raw.cast_to_varchar2('596566130063006D00"
"700070'),utl_raw.cast_to_varchar2('59656613884C4E1A002D79FB52A8301000320031"
"3011'),utl_raw.cast_to_varchar2('5E7F897F0031003000360035003530100032003530"
"11'),utl_raw.cast_to_varchar2('5E7F897F8054901A0031003000360035003530100032"
"00363011'),utl_raw.cast_to_varchar2('5F205E8665B0884C4E1A0031003500390033')"
",utl_raw.cast_to_varchar2('5F694FE1002D8F6F4E91301000390031901A90533011'),u"
"tl_raw.cast_to_varchar2('5FEB901F6D4B8BD53010003600303011'),utl_raw.cast_to"
"_varchar2('63078054003100300036003955468D853010003300353011'),utl_raw.cast_"
"to_varchar2('630780540031003000360039884C4E1A3010003500323011'),'c€T殞嬃x"
"?怱0Yu(0',utl_raw.cast_to_varchar2('65B0988657DF003100300036003630105E7"
"F544A3011'),'f|s圠N',utl_raw.cast_to_varchar2('66137C73884C4E1A3010003100"
"313011'),utl_raw.cast_to_varchar2('667A660E75354FE13010003300373011'),utl_r"
"aw.cast_to_varchar2('67EF603B80548DE8002D00390031'),'keN慶?,utl_raw.cast"
"_to_varchar2('6C5F82CF00310030003600350037'),utl_raw.cast_to_varchar2('6C5F"
"897F0031003000360035003965B03010003300393011002D00390031'),utl_raw.cast_to_"
"varchar2('6D596C5F7ECD5174FF080062006A00680078FF09301000353011002D00390031'"
"),utl_raw.cast_to_varchar2('6D596C5F96C64FE1901A002D00500031301000333011'),"
"utl_raw.cast_to_varchar2('6D596C5F96C64FE1901AFF080062006A00680078FF09002D6"
"5B0301000353011'),utl_raw.cast_to_varchar2('6D596C5F96C64FE1901AFF080062006"
"A00790079FF09002D0050003130100034'),utl_raw.cast_to_varchar2('72317279751F3"
"010003600303011002D00390031'),utl_raw.cast_to_varchar2('75354FE100310030003"
"600350039'),'u5O醰魪?,utl_raw.cast_to_varchar2('75354FE176F48FDE0031'),utl"
"_raw.cast_to_varchar2('76F48FDE00300034003600340035'),utl_raw.cast_to_varch"
"ar2('76F48FDE003100320037'),utl_raw.cast_to_varchar2('76F48FDE0031003200370"
"0320032003700370030'),utl_raw.cast_to_varchar2('79FB52A80031003000360035003"
"7'),utl_raw.cast_to_varchar2('79FB52A8738B672C002D002E00390031'),utl_raw.ca"
"st_to_varchar2('7EF47EB3591A4E097F51002D00390031'),utl_raw.cast_to_varchar2"
"('80015F200063006D0070007079FB52A8884C4E1A'),utl_raw.cast_to_varchar2('8001"
"5F2079FB52A8884C4E1A3010003500393011'),'€_ 弆c?,utl_raw.cast_to_varchar2("
"'8054901A00310030003600350035'),utl_raw.cast_to_varchar2('8054901A55468D853"
"010003200333011002D00500031'),utl_raw.cast_to_varchar2('805A4FE100337F51540"
"84E00884C4E1A'),'哯b邜怱',utl_raw.cast_to_varchar2('865A62DF901A90530030')"
",utl_raw.cast_to_varchar2('884C4E1A003100300036003900303010003500443011002D"
"4E0A6D77FF080031'),utl_raw.cast_to_varchar2('884C4E1A59077528003000340036')"
",'嬳楏^TJ','嬳楏w鞳?,utl_raw.cast_to_varchar2('8F6F4E91003100300036003500"
"38842595003010003200373011'),utl_raw.cast_to_varchar2('8F6F4E91003100300036"
"0039002D96336D0B'),utl_raw.cast_to_varchar2('8F6F4E910031003000360039003084"
"25950030104F1A5458901A301130100033'),'徣徿_iO?,utl_raw.cast_to_varchar2('9"
"1CD5E860031003000360035003700350036003300320032003000333010539F'),utl_raw.c"
"ast_to_varchar2('91CD5E8600310030003600350037003500360033003200320031003030"
"107075'),utl_raw.cast_to_varchar2('91CD5E8600310030003600350037827E901A'),'"
"懲^唝鸕?,utl_raw.cast_to_varchar2('91CD5E8679FB52A800310030003600350037884"
"C4E1A3010003500373011'),utl_raw.cast_to_varchar2('96336D0B667A660E003100300"
"03600350037'),'殞嬃xYu(€T嬟fz€?,'炑T
SU?怱'); SREC.NOVALS := DBMS_STATS"
".NUMARRAY(993852926114415000000000000000000,9938529261144150000000000000000"
"00,993852926114415000000000000000000,993852926114415000000000000000000,9938"
"52926114415000000000000000000,993852926114415000000000000000000,99385292611"
"4415000000000000000000,993852926114415000000000000000000,993852926114415000"
"000000000000000,993852926114415000000000000000000,9938529261144150000000000"
"00000000,993852926114415000000000000000000,99385292611441500000000000000000"
"0,993852926114415000000000000000000,993852926114415000000000000000000,99385"
"2926114415000000000000000000,993852926114415000000000000000000,993852926114"
"415000000000000000000,993852926114415000000000000000000,9938529261144150000"
"00000000000000,993852926114415000000000000000000,99385292611441500000000000"
"0000000,993852926114415000000000000000000,993852926114415000000000000000000"
",993852926114415000000000000000000,993852926114415000000000000000000,993852"
"926114415000000000000000000,993852926114415000000000000000000,9938529261144"
"15000000000000000000,993852926114415000000000000000000,99385292611441500000"
"0000000000000,993852926114415000000000000000000,993852926114415000000000000"
"000000,993852926114415000000000000000000,993852926114415000000000000000000,"
"1014136264173100000000000000000000,2028271909338390000000000000000000,22716"
"45185357320000000000000000000,2454202510774230000000000000000000,4051917836"
"97301000000000000000000000,405918619599335000000000000000000000,40591861959"
"9335000000000000000000000,405920031146600000000000000000000000,405923665410"
"223000000000000000000000,406061918442833000000000000000000000,4147663824146"
"96000000000000000000000,426326494068423000000000000000000000,43293467372514"
"6000000000000000000000,437214126327394000000000000000000000,462265679351240"
"000000000000000000000,462952508601792000000000000000000000,4629525086017920"
"00000000000000000000,464171030932828000000000000000000000,46417103109713400"
"0000000000000000000,490662664285030000000000000000000000,490662664439940000"
"000000000000000000,493924727709328000000000000000000000,4954041832283730000"
"00000000000000000,498045986399234000000000000000000000,51418953306394800000"
"0000000000000000,514189533063948000000000000000000000,514189533250554000000"
"000000000000000,528003771060183000000000000000000000,5300095054007240000000"
"00000000000000,530009505400724000000000000000000000,53209681928926100000000"
"0000000000000,539661696642719000000000000000000000,557630512025662000000000"
"000000000000,562705253358864000000000000000000000,5627057831972000000000000"
"00000000000,567774078230943000000000000000000000,56777407825992400000000000"
"0000000000,567774078259924000000000000000000000,567774078259924000000000000"
"000000000,592924749543354000000000000000000000,6085800288167660000000000000"
"00000000,608580028960342000000000000000000000,60858002896034200000000000000"
"0000000,617651335583539000000000000000000000,617651335583544000000000000000"
"000000,617651335583544000000000000000000000,6333653533962700000000000000000"
"00000,633365353535723000000000000000000000,65918835037269200000000000000000"
"0000,664641816881488000000000000000000000,664641817028488000000000000000000"
"000,664641817054409000000000000000000000,6663291372014080000000000000000000"
"00,666329137304269000000000000000000000,66644574341599600000000000000000000"
"0,697601029457290000000000000000000000,697601029457290000000000000000000000"
",707700023734132000000000000000000000,707700023841530000000000000000000000,"
"726548233184044000000000000000000000,726548233214786000000000000000000000,7"
"44756022908720000000000000000000000,744756022908720000000000000000000000,74"
"4756022908720000000000000000000000,746566330520498000000000000000000000,757"
"048427374798000000000000000000000,757048427374798000000000000000000000,7570"
"48427374798000000000000000000000,757048427522033000000000000000000000,75704"
"8427522033000000000000000000000,779887571067948000000000000000000000,802464"
"326149149000000000000000000000,824628586545367000000000000000000000); SREC."
"BKVALS := DBMS_STATS.NUMARRAY(1,2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,18,19"
",20,21,22,23,24,25,26,27,28,29,30,31,32,33,35,36,37,38,39,44,45,46,47,48,49"
",50,51,52,53,54,55,56,57,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,75,76"
",77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,1"
"01,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116); SREC.EPC :"
"= 108; DBMS_STATS.SET_COLUMN_STATS(NULL,'"BASE_CHANNELINFO"','"CHANNELNAME""
"', NULL ,NULL,NULL,108,.00431034482758621,0,srec,21,6); END;"
IMP-00003: 閬囧埌 ORACLE 閿欒 6550
ORA-06550: 绗?1 琛? 绗?4741 鍒?
PLS-00103: 鍑虹幇绗﹀彿 "6"鍦ㄩ渶瑕佷笅鍒椾箣涓€鏃讹細
) , * & = - + <
   / > 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, 浠ヤ笅璇彞澶辫触:


求助:这个问题怎么解决呢?
标签: 暂无标签
洛阳纸贵

写了 3 篇文章,拥有财富 60,被 2 人关注

转播转播 分享分享 分享淘帖
回复

使用道具

成为第一个吐槽的人

您需要登录后才可以回帖 登录 | 加入社区

本版积分规则

意见
反馈