Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎ½«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µÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂ
ÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVR ......

ORACLE ¶¯Ì¬Óï¾ä

 ÔÚÒ»°ãµÄPL/SQL³ÌÐò¿ª·¢ÖУ¬¿ÉÒÔʹÓÃSQLµÄDMLÓï¾äºÍÊÂÎñ¿ØÖÆÓï¾ä£¬µ«ÊÇDDLÓï¾ä¼°»á»°Óï¾äÈ´²»ÄÜÔÚPL/SQLÖÐÖ±½ÓʹÓã¬ÒªÏëʵÏÖÔÚPL/SQLÖÐʹÓÃDDLÓï¾ä¼°»á»°¿ØÖÆÓï¾ä£¬¿ÉÒÔͨ¹ý¶¯Ì¬SQLÀ´ÊµÏÖ¡£
       Ëùν¶¯Ì¬SQLÊÇÖ¸ÔÚPL/SQL¿é±àÒëʱSQLÓï¾äÊDz»È·¶¨µÄ£¬ÀýÈç¸ù¾ÝÓû§ÊäÈë²ÎÊýµÄ²»Í¬¶ø ......

oracle 10g°²×°ÖгöÏÖÎÊÌâ½â¾ö¹ý³Ì

      ÔÚ°²×°oracleµÄDBCA¹ý³ÌÖУ¬ÔÚ´´½¨²¢Æô¶¯oracleʵÀý£¨´´½¨¿Ë¡Êý¾Ý¿â£¬½ø¶ÈÌõÔÚ45%£©¾Í½øÐв»ÏÂÈ¥ÁË£¬ÖØ×°Á˼¸´ÎÖÕÓÚÕÒµ½ÎÊÌâµÄÖ¢½áÁË£¬½â¾ö¹ý³ÌÈçÏ£º
      1¡¢×°Á˼¸±é¾ÍÊÇÄǸöÎÊÌ⣬ÎÒͻȻÏëµ½Òª¿´¿´°²×°ÈÕÖ¾¡£
      2¡¢ÊÇÔÚ´´½ ......

Oracle¡¢SQL Server¡¢AccessÊý¾Ý¿â¸ßЧ¹û·ÖÒ³¼¼ÇÉ

 ÔÚ³ÌÐòµÄ¿ª·¢¹ý³ÌÖУ¬´¦Àí·ÖÒ³ÊÇ´ó¼Ò½Ó´¥±È½ÏƵ·±µÄʼþ£¬ÒòΪÏÖÔÚÈí¼þ»ù±¾É϶¼ÊÇÓëÊý¾Ý¿â½øÐйҵöµÄ¡£µ«Ð§ÂÊÓÖÊÇÎÒÃÇËù×·ÇóµÄ£¬Èç¹ûÊÇÏñÔ­À´ÄÇÑù°ÑËùÓÐÂú×ãÌõ¼þµÄ¼Ç¼ȫ²¿¶¼Ñ¡Ôñ³öÀ´£¬ÔÙÈ¥½øÐзÖÒ³´¦Àí£¬ÄÇô¾Í»á¶à¶àµÄÀ˷ѵôÐí¶àµÄϵͳ´¦Àíʱ¼ä¡£ÎªÁËÄܹ»°ÑЧÂÊÌá¸ß£¬ËùÒÔÏÖÔÚÎÒÃǾÍֻѡÔñÎÒÃÇÐèÒªµÄÊý¾Ý£¬¼õÉÙÊý¾Ý ......

²»°²×°Oracle¿Í»§¶ËÔ¶³ÌÁ¬½ÓOrcaleÊý¾Ý¿â

×î½üÓÐÒ»ÈÎÎñ£¬ÐèҪʹÓÃOracleÊý¾Ý¿â£¬ÒÔǰ¶Ô´Ë²»Ì«ÊìϤ£¬¾Í´ÓÍøÉϲéÕÒ×ÊÁÏ£¬£¨ËµÊµÔÚµÄÍøÂçÕæÊÇÌ«ºÃÁË£¬Ò²¶à¿÷ÁËÐí¶àµÄÈÈÐĵļ¼ÊõÈËÔ±£¬Ô¸Òâ°Ñ×Ô¼ºµÄ¾­ÑéºÍÐĵÃÓë´ó¼Ò·ÖÏí£©²¢×ªÌùÁËÒ»¸öÌû×Ӳο¼£¬²»¹ý´ËÌû×ÓÓÐЩµØ·½Ã»ÓÐ˵Çå³þ£¬È·ÊµÈÃÎÒ·ÑÁ˺ô󾢣¬²Å²âÊԳɹ¦¡£ÏÂÃæÎÒ°ÑÎҵIJ½Öè˵Ã÷һϣº£¨»·¾³£ºWindows XP sp2 + vs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ