ÈçºÎ½«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
Ïà¹ØÎĵµ£º
´æ´¢¹ý³ÌÔÚ·þÎñÆ÷¶ËÔçÒѱà¼Ö´ÐйýµÄ´úÂë¡£Óû§Òª×öµÄÖ»Êǵ÷ÓúͽÓÊÕ´æ´¢¹ý·µ»ØµÄ½á¹û¡£ËùÒÔµ÷Óô洢¹ý³Ì±ÈÆÕͨµÄÓòéѯÓï¾ä·µ»ØÖµÒª¿ìµÃ¶à,´æ´¢¹ý³ÌµÄÖ´ÐÐËٶȸü¿ì,´æ ´¢¹ý³ÌÊDZ£´æÆðÀ´µÄ¿ÉÒÔ½ÓÊܺͷµ»ØÓû§ÌṩµÄ²ÎÊýµÄ Transact-SQL Óï¾äµÄ¼¯ºÏ¡£¿ÉÒÔ´´½¨Ò»¸ö¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°ÖÐÁÙʱʹÓ㨾ֲ¿ÁÙʱ¹ý ......
ÔÚ°²×°oracleµÄDBCA¹ý³ÌÖУ¬ÔÚ´´½¨²¢Æô¶¯oracleʵÀý£¨´´½¨¿Ë¡Êý¾Ý¿â£¬½ø¶ÈÌõÔÚ45%£©¾Í½øÐв»ÏÂÈ¥ÁË£¬ÖØ×°Á˼¸´ÎÖÕÓÚÕÒµ½ÎÊÌâµÄÖ¢½áÁË£¬½â¾ö¹ý³ÌÈçÏ£º
1¡¢×°Á˼¸±é¾ÍÊÇÄǸöÎÊÌ⣬ÎÒͻȻÏëµ½Òª¿´¿´°²×°ÈÕÖ¾¡£
2¡¢ÊÇÔÚ´´½ ......
oracle ·½·¨ & ......
ÔÚ³ÌÐòµÄ¿ª·¢¹ý³ÌÖУ¬´¦Àí·ÖÒ³ÊÇ´ó¼Ò½Ó´¥±È½ÏƵ·±µÄʼþ£¬ÒòΪÏÖÔÚÈí¼þ»ù±¾É϶¼ÊÇÓëÊý¾Ý¿â½øÐйҵöµÄ¡£µ«Ð§ÂÊÓÖÊÇÎÒÃÇËù×·ÇóµÄ£¬Èç¹ûÊÇÏñÔÀ´ÄÇÑù°ÑËùÓÐÂú×ãÌõ¼þµÄ¼Ç¼ȫ²¿¶¼Ñ¡Ôñ³öÀ´£¬ÔÙÈ¥½øÐзÖÒ³´¦Àí£¬ÄÇô¾Í»á¶à¶àµÄÀ˷ѵôÐí¶àµÄϵͳ´¦Àíʱ¼ä¡£ÎªÁËÄܹ»°ÑЧÂÊÌá¸ß£¬ËùÒÔÏÖÔÚÎÒÃǾÍֻѡÔñÎÒÃÇÐèÒªµÄÊý¾Ý£¬¼õÉÙÊý¾Ý ......
Êý¾Ý¿âµÄÆô¶¯ÓÐÈýÖÖ£º
1
£º
startup nomount
ÕâÖÖ¹ý³ÌÓÖ³ÆÎª£º·Ç°²×°Æô¶¯
Æô¶¯¹ý³ÌΪ£ºÆô¶¯
oracle
ʵÀý£¬²»¼ÓÔØÊý¾Ý¿â£¬²»´ò¿ªÊý¾Ý¿â¡£ÔÚÕâ¸ö¹ý³ÌÖÐÖ»ÐèÒª
init.ora
³õʼ»¯²ÎÊýÎļþ£¬Öؽ¨¿ØÖÆÎļþ£¬¼´Æô¶¯ ......