ÈçºÎ½«TXT,EXCEL»òCSVÊý¾Ýµ¼ÈëORACLEµ½¶ÔÓ¦±íÖÐ
·½·¨Ò»£¬Ê¹ÓÃSQL*Loader
Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ´æÔÚ¡£
´óÌå²½ÖèÈçÏ£º
1 ½«excleÎļþÁí´æÎªÒ»¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡ÔñÀàÐÍΪcsv£¨¶ººÅ·Ö¸ô£©Ò²ÐУ¬µ«ÊÇÔÚдºóÃæµÄcontrol.ctlʱҪ½«×Ö¶ÎÖÕÖ¹·û¸ÄΪ','(fields terminated by ','£©£¬¼ÙÉè±£´æµ½EÅ̸ùĿ¼¡£
2 Èç¹ûûÓдæÔڵıí½á¹¹£¬Ôò´´½¨,¼ÙÉè±íΪtest£¬ÓÐÁ½ÁÐΪdm£¬ms¡£
3 ÓüÇʱ¾´´½¨SQL*Loader¿ØÖÆÎļþ£¬ÍøÉÏ˵µÄÎļþÃûºó׺Ϊctl£¬ÆäʵÎÒ×Ô¼º·¢ÏÖ¾ÍÓÃtxtºó׺ҲÐС£±ÈÈçÃüÃûΪcontrol.ctl£¬ÄÚÈÝÈçÏ£º(--ºóÃæµÄΪעÊÍ£¬Êµ¼Ê²»ÐèÒª£©
¡¡¡¡load data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ --¿ØÖÆÎļþ±êʶ
¡¡¡¡infile 'e:\text.csv'¡¡¡¡¡¡¡¡ --ÒªÊäÈëµÄÊý¾ÝÎļþÃûΪtest.txt
¡¡¡¡append into table test¡¡¡¡ --Ïò±ítestÖÐ×·¼Ó¼Ç¼
¡¡¡¡fields terminated by X'09'¡¡--×Ö¶ÎÖÕÖ¹ÓÚX'09'£¬ÊÇÒ»¸öÖÆ±í·û£¨TAB£©
Èç¹û×Ö¶ÎÊý¾ÝÓÐ"",¿É¼ÓÉÏoptionally enclosed by '"'
trailing nullcols
¡¡¡¡(dm,ms)¡¡¡¡ --¶¨ÒåÁжÔӦ˳Ðò
±¸×¢£ºÊý¾Ýµ¼ÈëµÄ·½Ê½ÉÏÀýÖÐÓõÄappend£¬ÓÐһϼ¸ÖÖ£ºinsert£¬ÎªÈ±Ê¡·½Ê½£¬ÔÚÊý¾Ý×°ÔØ¿ªÊ¼Ê±ÒªÇó±íΪ¿Õ£»append£¬ÔÚ±íÖÐ×·¼ÓмǼ£»replace£¬É¾³ý¾É¼Ç¼£¬Ìæ»»³ÉÐÂ×°ÔØµÄ¼Ç¼ £»truncate£¬Í¬replace¡£
4 ÔÚÃüÁîÐÐÌáʾ·ûÏÂʹÓÃSQL*LoaderÃüÁîʵÏÖÊý¾ÝµÄÊäÈë
sqlldr userid=system/manager@orcl control='e:\control.ctl' log=e:\l
Ïà¹ØÎĵµ£º
ORACLEÏà¹ØÓï·¨ ÊÕ²Ø
Ò»¡¢OracleÈëÃÅ
ÀíÂÛ֪ʶ£º
OracleµÄÎïÀí×é¼þÓÐÈý¸ö£º
(1)Êý¾ÝÎļþ Êý¾ÝÎļþÊÇÓÃÓÚ´æ´¢Êý¾Ý¿âÊý¾ÝµÄÎļþ£¬Èç±í¡¢Ë÷ÒýÊý¾Ý¡£Ã¿¸öOracleÊý¾Ý¿âÓÐÒ»¸ö»ò¶à¸öÎïÀíÊý¾ÝÎļþ£¬
&nbs ......
Ó¦¸ö±¨±íÒªÇó×ö¸ö
ʱ¼ä ˫ɫÇò£¬ ʤ¸º²Ê¡£¡£¡£¡£¡£
200905 ÏúÁ¿ ÏúÁ¿
200906 ÏúÁ¿ ÏúÁ¿
200907 &n ......
´æ´¢¹ý³ÌÔÚ·þÎñÆ÷¶ËÔçÒѱà¼Ö´ÐйýµÄ´úÂë¡£Óû§Òª×öµÄÖ»Êǵ÷ÓúͽÓÊÕ´æ´¢¹ý·µ»ØµÄ½á¹û¡£ËùÒÔµ÷Óô洢¹ý³Ì±ÈÆÕͨµÄÓòéѯÓï¾ä·µ»ØÖµÒª¿ìµÃ¶à,´æ´¢¹ý³ÌµÄÖ´ÐÐËٶȸü¿ì,´æ ´¢¹ý³ÌÊDZ£´æÆðÀ´µÄ¿ÉÒÔ½ÓÊܺͷµ»ØÓû§ÌṩµÄ²ÎÊýµÄ Transact-SQL Óï¾äµÄ¼¯ºÏ¡£¿ÉÒÔ´´½¨Ò»¸ö¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°ÖÐÁÙʱʹÓ㨾ֲ¿ÁÙʱ¹ý ......
ÔÚ°²×°oracleµÄDBCA¹ý³ÌÖУ¬ÔÚ´´½¨²¢Æô¶¯oracleʵÀý£¨´´½¨¿Ë¡Êý¾Ý¿â£¬½ø¶ÈÌõÔÚ45%£©¾Í½øÐв»ÏÂÈ¥ÁË£¬ÖØ×°Á˼¸´ÎÖÕÓÚÕÒµ½ÎÊÌâµÄÖ¢½áÁË£¬½â¾ö¹ý³ÌÈçÏ£º
1¡¢×°Á˼¸±é¾ÍÊÇÄǸöÎÊÌ⣬ÎÒͻȻÏëµ½Òª¿´¿´°²×°ÈÕÖ¾¡£
2¡¢ÊÇÔÚ´´½ ......