弱弱的问题

imfjl 2003-07-06 02:58:06
现在有一个oracle安装在linux下,又有一个oracle安装在win2000下。现在我想把linux下某个数据库里的所有表全部复制到win2000下的oracle.最简单的方法是什么?我可以通过网络联到linux下的oracle.而本机是装了oracle的win2000
...全文
9 点赞 收藏 6
写回复
6 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
imfjl 2003-07-10
嘿嘿,解决了。最简单的方法就是用同一个版本的导入导出。可以通过网络用本机的导出将远程的数据库导出,再用本机的导入。这样就没有语言问题了。
回复
own8888 2003-07-07
Following is the NLS supported character sets:

Id Character set Description
--------------------------------------------------------
001 US7ASCII ASCII 7-bit American
002 WE8DEC West European
003 WE8HPHP LaserJet West European
004 US8PC437 Code Page 437 American
005 WE8EBCDIC37 Code Page 37 West European
006 WE8EBCDIC500 Code Page 500 West European
010 WE8PC850 Code Page 850 West European
011 D7DEC VT100 7-bit German
012 F7DEC VT100 7-bit French
013 S7DEC VT100 7-bit Swedish
014 E7DEC VT100 7-bit Spanish
015 SF7ASCII ASCII 7-bit Finnish
016 NDK7DEC VT100 7-bit Norwegian/Danish (Norwegian sort)
017 I7DEC VT100 7-bit Italian
018 NL7DEC VT100 7-bit Dutch
019 CH7DEC VT100 7-bit Swiss (German & French)
020 DKN7DEC Danish sort DEC VT100 7-bit Norwegian/Danish
021 SF7DEC VT100 7-bit Finnish
022 TR7DEC VT100 7-bit Turkish
031 WE8ISO8859P1 ISO 8859-1 West European
032 EE8ISO8859P2 ISO 8859-2 East European
033 SE8ISO8859P3 ISO 8859-3 South European
034 NEE8ISO8859P4 ISO 8859-4 North and North-East European
035 CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic
036 AR8ISO8859P6 ISO 8859-6 Latin / Arabic
037 EL8ISO8859P7 ISO 8859-7 Latin / Greek
038 IW8ISO8859P8 ISO 8859-8 Latin / Hebrew
039 WE8ISO8859P9 ISO 8859-9 West European & Turkish
041 TH8TISASCII Thai Industrial Standard 620-2533 (ASCII)
042 TH8TISEBCDIC Thai Industrial Standard 620-2533 (EBCDIC)
081 EL8DEC Latin / Greek
082 TR8DEC Turkish
090 WE8EBCDIC37C Code Page 37 Oracle/c
091 WE8EBCDIC500C Code Page 500 Oracle/c
100 EEC8EUROPC EURO-PC West European/Greek
101 EEC8EECEUROUNIX EURO-UNIX West European/Greek
102 WE8EEC8859P1 EURO-UNIX copy of ISO 8859-1
103 EL8EEC8859P7 EURO-UNIX copy of ISO 8859-7
110 EEC8EUROASCI Targon 35 ASCI West European/Greek
111 EEC8ISO8859P1 Targon 35 copy of ISO 8859-1
112 EEC8ISO8859P7 Targon 35 copy of ISO 8859-7
113 EEC8EUROPA3 EUROPA3 West European/Greek
154 HU8ISO8859P2 Hungarian sort ISO 8859-2
150 EE8PC852 Code Page 852 East European
152 RU8PC866 Code Page 866 Latin/Cyrillic
153 RU8BESTA BESTA Latin/Cyrillic
155 RU8PC855 Code Page 855 Latin/Cyrillic
156 TR8PC857 Code Page 857 Turkish
157 CL8MSWINDOW31 Windows 3.1 Latin/Cyrillic
158 CL8MACCYRILLIC Mac Latin/Cyrillic
160 WE8PC860 Code Page 860 West European
180 D8EBCDIC273 Code Page 273/1 Austrian/German
181 I8EBCDIC280 Code Page 280/1 Italian
182 DK8EBCDIC277 Code Page 277/1 Danish
183 S8EBCDIC278 Code Page 278/1 Swedish
190 N8PC865 Code Page 865 Norwegian
201 F7SIEMENS9780X 97801/97808 7-bit French
202 E7SIEMENS9780X 97801/97808 7-bit Spanish
203 S7SIEMENS9780X 97801/97808 7-bit Swedish
204 DK7SIEMENS9780X 97801/97808 7-bit Danish
205 N7SIEMENS9780X 97801/97808 7-bit Norwegian
206 I7SIEMENS9780X 97801/97808 7-bit Italian
207 D7SIEMENS9780X 97801/97808 7-bit German
221 US8BS200 9750-62 EBCDIC American
222 D8BS2000 9750-62 EBCDIC German
223 F8BS2000 9750-62 EBCDIC French
224 E8BS200 9750-62 EBCDIC Spanish
225 DK8BS2000 9750-62 EBCDIC Danish
231 WE8BS2000 EBCDIC.DF.04 West European
239 WE8BS2000L5 Siemens EBCDI+.DF.04.L5 WE & Turkish
241 WE8DG DG West European
251 WE8NCR4970 NCR 4970 West European
261 WE8ROMAN8 HP Roman8 West European
301 N8ISO8859P1 Norwegian sort ISO 8859-1
302 N8DEC Norwegian sort West European
303 N8HP Norwegian sort HP LaserJet
304 N8EBCDIC37 Norwegian sort Code Page 37
305 N8EBCDIC500 Norwegian sort Code Page 500
306 N8PC850 Norwegian sort Code Page 850
307 N8ROMAN8 Norwegian sort HP Roman8
311 DK8ISO8859P1 Danish sort ISO 8859-1
312 DK8DEC Danish sort West European
313 DK8HP Danish sort HP LaserJet
314 DK8EBCDIC37 Danish sort Code Page 37
315 DK8EBCDIC500 Danish sort Code Page 500
316 DK8PC850 Danish sort Code Page 850
317 DK8ROMAN8 Danish sort HP Roman8
321 S8ISO8859P1 Swedish sort ISO 8859-1
322 S8DEC Swedish sort West European
323 S8HP Swedish sort HP LaserJet
324 S8EBCDIC37 Swedish sort Code Page 37
325 S8EBCDIC500 Swedish sort Code Page 500
326 S8PC850 Swedish sort Code Page 850
327 S8ROMAN8 Swedish sort HP Roman8
331 SF8ISO8859P1 Finnish sort ISO 8859-1
332 SF8DEC Finnish sort West European
333 SF8HP Finnish sort HP LaserJet
334 SF8EBCDIC37 Finnish sort Code Page 37
335 SF8EBCDIC500 Finnish sort Code Page 500
336 SF8PC850 Finnish sort Code Page 850
337 SF8ROMAN8 Finnish sort HP Roman8
341 IS8ISO8859P1 Icelandic sort ISO 8859-1
351 WE8MACROMAN8 Mac Extended ROMAN8 West European
360 SK8ISO8859P2 Slovak sort ISO 8859-2
361 SK8PC852 Slovak sort Code Page 852
363 HU8PC852 Hungarian sort Code Page 852
364 CS8ISO8859P2 Czech sort ISO 8859-2
365 CS8PC852 Czech sort Code Page 852
366 PL8ISO8859P2 Polish sort ISO 8859-2
367 PL8PC852 Polish sort Code Page 852
368 HU8CWI2 Hungarian CWI-2
370 TR8ISO8859P9 Turkish version ISO 8859-9
380 EL8PC437S Greek modified Code Page 437
381 EL8EBCDIC875 Code Page 875 Greek
390 CDN8PC863 Code Page 863 Canadian French
401 HU8ABMOD Hungarian AB Mod
401 HU8ABMOD Hungarian AB Mod
590 LA8TELETEX Teletex Latin
829 JA16VMS Japanese VMS Kanji
830 JA16EUC Japanese Extended UNIX Code
832 JA16SJIS Japanese Shift-JIS
833 JA16DBCS Japanese IBM
839 JA16THOSHIBAEUC Toshiba version of JEUC
843 JA16HP Japanese HP
840 KO16KSC5601 Korean KSC5601
842 KO16DBCS Korean IBM
850 ZHS16CGB231280 Chinese GB2312-80
860 ZHT32CNS1164386 Taiwan Traditional Chinese
865 ZHT16BIG5 Big5 Traditional Chinese
回复
Rolei_zzl 2003-07-06
1、修改字符集,保证linux和win2000下的字符集一致;
2、安装一个中文的客户端,通过这个客户端导出LINUX中的表,然后再导入WIN2000中,也就是用一个中文字符集的客户端做中介;
回复
yiyi1977 2003-07-06
修改你的数据库的字符集。
回复
imfjl 2003-07-06
晕.......试过导入导出。结果,linux下用的是英语版,而win2000下用的是中文版。导入的时候出现错误:
IMP-00016: 不支持要求的字符集转换(从类型31到852)
IMP-00000: 未成功终止导入
回复
Rolei_zzl 2003-07-06
导入导出
回复
相关推荐
发帖
基础和管理
创建于2007-09-28

1.7w+

社区成员

Oracle 基础和管理
申请成为版主
帖子事件
创建了帖子
2003-07-06 02:58
社区公告
暂无公告