ÎÒÒªÌáÎ殾ȢÊ×Ò³ > ÉͽðÉçÇø > µçÄÔÍøÂç > ²é¿´ÎÊÌâ

ÒѾ­½â¾ö sqlserverÖÐÊý¾ÝÔõôתÈëµ½OracleÖÐ

ÐüÉÍ: 5 ½ð±Ò   ÌáÎÊÓÚ2008-11-18 14:23:37  ½â¾öʱ¼ä:2008-11-24 08:43:11

Òª°ÑsqlserverÖÐijЩ±íÖÐÊý¾Ýµ¼Èëµ½OracleÖÐijЩ±íÖУ¬¾ßÌåÒªÔõô×ö°¡
Óм¸ÖÖ·½·¨Ñ½£¬×î¼òµ¥Ôõô×öѽ£¬³õ³öé®ɶҲ²»¶®£¬ÇëÖ¸½Ì£¬²»Ê¤¸Ð¼¤£¬
»Ø´ðºó¸ß·ÖÐüÉÍ£¡£¡£¡

ÎÒÀ´ÆÀÂÛ   Êղص½¿Ú´ü

»Ø´ðÓÚ 2008-11-18 17:40:52   

1.
sqlserver µ¼³ö¸ñʽÎļþ£¬Îļþ×Ö¶ÎÖ®¼ä°´ÕÕÒ»¶¨µÄÌØÊâ×Ö·û¸ô¿ª£¬Èç¡°|¡±¡£È»ºó±£´æ³ÉÒ»¸öÎı¾Îļþ£¬Èç¡£test.txt
---------------------------------------
2.
ÒÔÏÂÓï¾ä±£´æ³É ctlºó׺Îļþ£¬ÕâÀïΪzj.ctl.
load data
infile 'test.txt' --- Äã±£´æµÄÎı¾ÎļþÃû
into table table_name ---ÄãÒªµ¼ÈëµÄoracle±íÃû
fields terminated by '|' trailing nullcols
(
field1,---Îı¾ÎļþÓëÊý¾Ý¿â×ֶζÔÓ¦¹ØÏµ
field2,
...
fieldn
)
-----------------------------------------
3.
Åú´¦ÀíÎļþ£¬±£´æ³Ébat¸ñʽÎļþ
sqlldr Êý¾Ý¿âÓû§Ãû/Êý¾Ý¿âÃÜÂë@Êý¾Ý¿âTNSÃû³Æ control=zj.ctl log=zj.log
bad=zj.bad errors=9999
-----------------------------------------
4.Ë«»÷batÎļþÖ´ÐÐ
Èç¹û±¨´í£¬Çë²é¿´logÎļþÐÅÏ¢

»Ø´ðÓÚ 2008-11-19 14:39:04   

ÎÒ²»¶®£¬À´¸øÄã´ÕÈËÆø¡£

°´»Ø´ðʱ¼ä | °´ÆÀ¼Û¸ßµÍÍøÓѻشð(¹²3¸ö»Ø´ð)

121.28.98.*

»Ø´ðÓÚ 2008-11-18 16:35:01 1Â¥

µ¼³ÉinsertÓï¾äÔÙµ½OracleÖÐÖ´ÐÐ

 1 

Copyright©2008 Qihoo.com All Rights Reserved Ææ»¢Íø
ÀÈ·»±¨¾¯·þÎñ

&bnsp;