ºÇ½ª¹¹¿·¡§
daidaibousi 2009ǯ03·î21Æü(ÅÚ) 23:21:24ÍúÎò
¥³¥Þ¥ó¥É¥é¥¤¥ó¤Ç¤è¤¯»È¤¦¥Ñ¥é¥á¡¼¥¿¤ò¥Õ¥¡¥¤¥ë¤Ë»ØÄꤹ¤ë¡£
daily_report.par USERID=scott CONTROL=daily_report.ctl ERRORS=9999 LOG=daily_report.log $ sqlldr PARFILE=daily_report.par Password: password
- ¥»¥¥å¥ê¥Æ¥£¾å¡¢USERID¤Î¥Ñ¥¹¥ï¡¼¥É¤Ï´Þ¤á¤Ê¤¤¤³¤È¡£
- ¡¼¥¿¡¦¥Õ¥¡¥¤¥ë¤ËƱ¤¸ÆüÉÕ¤¬·«¤êÊÖ¤·¤Æ¸ºß¤¹¤ë¾ì¹ç¡¢¥À¥¤¥ì¥¯¥È¡¦¥Ñ¥¹¡¦¥í¡¼¥É¤Î®ÅÙ¤ò¸þ¾å¤Ç¤¤ë¡£
- ¥À¥¤¥ì¥¯¥È¡¦¥Ñ¥¹¡¦¥í¡¼¥É¤Î»þ¤Î¤ß
- ¥Ç¥Õ¥©¥ë¥È(DATE_CACHE=1000)¤Ç»ÈÍѲÄǽ
- ¤¿¤À¤·¡¢¥Ç¥Õ¥©¥ë¥ÈÃÍ(1000)¤ò±Û¤¨¤ë¤È¡¢¼«Æ°Åª¤Ë»ÈÍѶػߤˤʤë
- ¤¿¤È¤¨¤Ð¡¢DATE_CACHE=5000¤ò»ØÄꤹ¤ë¤È¡¢ºîÀ®¤µ¤ì¤¿ÆüÉÕ¥¥ã¥Ã¥·¥å¤´¤È¤ËºÇÂç5000¤Î°ì°Õ¤ÎÆüÉÕ¥¨¥ó¥È¥ê¤¬´Þ¤Þ¤ì¤ë¡£
- 0°Ê³°¤ÎÃͤò»ØÄꤷ¤¿¾ì¹ç¡¢¤½¤ÎÃͤò±Û¤¨¤Æ¤â¥¥ã¥Ã¥·¥å¤Ï»ÈÍѶػߤˤʤé¤Ê¤¤
¤³¤ì¤òÂ礤á¤Ë»ØÄꤷ¤Æ¤ª¤«¤Ê¤¤¤È¡¢ÅÓÃæ¤Ç¥í¡¼¥É¤¬½ªÎ»¤¹¤ë
- ÁÞÆþ¥¨¥é¡¼¤ÎµöÍƺÇÂç¿ô¤ò»ØÄê
- ȯÀ¸¤·¤¿¥¨¥é¡¼¤Î¿ô¤¬ERRORS¤Ë»ØÄꤵ¤ì¤¿ÃͤòĶ¤¨¤ë¤È¡¢¥í¡¼¥É½èÍý¤¬Ãæ»ß¤µ¤ì¤ë¡£
- ¥¨¥¯¥¹¥Æ¥ó¥È¤ò³ä¤êÅö¤Æ¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë¤ò»ØÄê
- ¥À¥¤¥ì¥¯¥È¡¦¥Ñ¥¹¤Î¥Ñ¥é¥ì¥ë¡¦¥â¡¼¥É¤Ç¤Î¤ß»ÈÍÑ
- SLQ*Loader¤Î°Û¤Ê¤ë¥×¥í¥»¥¹¤ËÂФ¹¤ë¡¢¥Ç¥£¥¹¥¯¤Î¶¥¹ç¤òºÇ¾®¸Â¤ËÍÞ¤¨¤ë
- ¥Ç¥Õ¥©¥ë¥È: Ê£¿ôCPU¥·¥¹¥Æ¥à¤Ç¤Ïtrue¤Ç¡¢Ã±°ìCPU¥·¥¹¥Æ¥à¤Ç¤Ïfalse
- ¥µ¡¼¥Ð¡¼¤Ç¤Î¥¹¥È¥ê¡¼¥à¤Î¥í¡¼¥É¤ÈʹԤ·¤Æ¡¢¥¯¥é¥¤¥¢¥ó¥È¤Ç¥¹¥È¥ê¡¼¥à¤òºîÀ®¤Ç¤¤ë
- ¥À¥¤¥ì¥¯¥È¡¦¥í¡¼¥É»þ¤ËÊ£¿ô¤ÎƱ»þ¥»¥Ã¥·¥ç¥ó¤Ë¤è¤Ã¤ÆƱ¤¸É½¤Ë¥Ç¡¼¥¿¤ò¥í¡¼¥É¤Ç¤¤ë¤«¤É¤¦¤«¤ò»ØÄê
- ½¾Íè·¿¥Ñ¥¹¡¦¥í¡¼¥É¤ÎÊýË¡¤Ç¤Ï¡¢¥Ð¥¤¥ó¥ÉÇÛÎó¤Ï¡¢Æɼè¤ê¥Ð¥Ã¥Õ¥¡¤Î¥µ¥¤¥º¤Ë¤è¤Ã¤ÆÀ©¸Â¤µ¤ì¤ë
- ¤½¤Î¤¿¤áÆɼè¤ê¥Ð¥Ã¥Õ¥¡¤òÂ礤¯¤¹¤ë¤È¡¢¥³¥ß¥Ã¥ÈÁàºî¤ò¼Â¹Ô¤¹¤ëÁ°¤Ë¡¢¤è¤ê¿¤¯¤Î¥Ç¡¼¥¿¤òÆɤ߼è¤ë¤³¤È¤¬¤Ç¤¤ë¡£
- READSIZE¤Ë1000000¤òÀßÄꤹ¤ë¤È¡¢¥³¥ß¥Ã¥È¤ò¼Â¹Ô¤¹¤ëÁ°¤Ë¡¢SQL*Loader¤Ë¤è¤Ã¤Æ¡¢³°Éô¤Î¥Ç¡¼¥¿¡¦¥Õ¥¡¥¤¥ë¤«¤é1,000,000¥Ð¥¤¥Èñ°Ì¤ÇÆɼè¤ê¤ò¼Â¹Ô¤Ç¤¤ë
- ½¾Íè·¿¥Ñ¥¹¡¦¥í¡¼¥É¤Î¾ì¹ç¤Î¤ß: ROWS¤Ç¥Ð¥¤¥ó¥ÉÇÛÎó¤Î¹Ô¿ô¤ò»ØÄê
- ¥À¥¤¥ì¥¯¥È¡¦¥Ñ¥¹¡¦¥í¡¼¥É¤Î¾ì¹ç¤Î¤ß: ROWS¤Ç¥Ç¡¼¥¿¡¦¥Õ¥¡¥¤¥ë¤«¤é¥Ç¡¼¥¿¤Î¥»¡¼¥ÖÁ°¤ËÆɤ߹þ¤à¹Ô¿ô¤ò»ØÄê
- HEADER: ²èÌ̤ËÄ̾ïɽ¼¨¤µ¤ì¤ëSQL*Loader¤Î¥Ø¥Ã¥À¡¼¡¦¥á¥Ã¥»¡¼¥¸¤òÈóɽ¼¨¤Ë
- FEEDBACK: ²èÌ̤ËÄ̾ïɽ¼¨¤µ¤ì¤ë¡Öcommit point reached¡×¥Õ¥£¡¼¥É¥Ð¥Ã¥¯¡¦¥á¥Ã¥»¡¼¥¸¤òÈóɽ¼¨¤Ë
- ERRORS: ¥¨¥é¡¼¤¬È¯À¸¤·¤¿¤¿¤á¤½¤Î¥ì¥³¡¼¥É¤¬ÉÔÎÉ¥Õ¥¡¥¤¥ë¤Ë½ñ¤¹þ¤Þ¤ì¤¿¾ì¹ç¡¢¥¨¥é¡¼¡¦¥á¥Ã¥»¡¼¥¸¤¬¥í¥°¡¦¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤµ¤ì¤Ê¤¤¤è¤¦¤Ë
- DISCARDS: ¥ì¥³¡¼¥É¤¬ÇÑ´þ¥Õ¥¡¥¤¥ë¤Ë½ñ¤¹þ¤Þ¤ì¤¿¾ì¹ç¤Ë¡¢¤½¤Î¤³¤È¤ò¼¨¤¹¥á¥Ã¥»¡¼¥¸¤¬¥í¥°¡¦¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤµ¤ì¤Ê¤¤¤è¤¦¤Ë
- PARTITIONS: ¥Ñ¡¼¥Æ¥£¥·¥ç¥óɽ¤Î¥À¥¤¥ì¥¯¥È¡¦¥í¡¼¥ÉÃæ¡¢¥í¥°¡¦¥Õ¥¡¥¤¥ë¤ËÂФ¹¤ë¥Ñ¡¼¥Æ¥£¥·¥ç¥ó¤´¤È¤ÎÅý·×¾ðÊó¤Î½ñ¹þ¤ß¤ò»ÈÍѶػߤË
- ALL: ¤¹¤Ù¤Æ¤ÎÍÞ»ßÃÍ¡ÊHEADER¡¢FEEDBACK¡¢ERRORS¡¢DISCARDS¤ª¤è¤ÓPARTITIONS¥Ñ¥é¥á¡¼¥¿¡Ë¤ò¼ÂÁõ
SILENT=(HEADER, FEEDBACK)
- ¥À¥¤¥ì¥¯¥È¡¦¥Ñ¥¹¡¦¥í¡¼¥É¤Îº÷°ú¥á¥ó¥Æ¥Ê¥ó¥¹¤òÄä»ß¤¹¤ë
- º÷°ú¥¡¼¤¬ÉÕ¤±¤é¤ì¤¿º÷°ú¥Ñ¡¼¥Æ¥£¥·¥ç¥ó¤Ë¤Ï¡¢º÷°ú¥¡¼¤Î¤«¤ï¤ê¤Ëº÷°ú»ÈÍѶػߤ¬ÀßÄꤵ¤ì¤ë
- º÷°ú»ÈÍѶػ߾õÂ֤κ÷°ú¤¬¸¡½Ð¤µ¤ì¤¿¾ì¹ç¡¢»ÈÍѶػ߾õÂ֤κ÷°ú¤Ï¥¹¥¥Ã¥×¤µ¤ì¡¢¥í¡¼¥É½èÍý¤Ï³¹Ô¤µ¤ì¤ë¡£
- ¤Ã¤Æ¥í¡¼¥É³«»ÏÁ°¤Î¾õÂÖ¤¬»ÈÍѶػߤκ÷°ú¤ò´Þ¤àɽ¤ò¥í¡¼¥É¤Ç¤¤ë¡£
- ¤É¤¦¤â¥í¡¼¥É¤¬Â®¤¯¤Ê¤ë¤È¤¤¤¦¥ª¥×¥·¥ç¥ó¤Ç¤Ï¤Ê¤¤¡©
- ¥í¡¼¥É»þ¤Ë»ÈÍѶػ߾õÂ֤Ǥʤ¤º÷°ú¤Ï¡¢SQL*Loader¤Ë¤è¤Ã¤Æ¥á¥ó¥Æ¥Ê¥ó¥¹¤µ¤ì¤ë
- ¥À¥¤¥ì¥¯¥È¡¦¥Ñ¥¹¡¦¥¹¥È¥ê¡¼¥à¡¦¥Ð¥Ã¥Õ¥¡¤Î¥µ¥¤¥º¤ò»ØÄꤹ¤ë
- Ê£¿ôCPU¥·¥¹¥Æ¥à¤Ç¥À¥¤¥ì¥¯¥È¡¦¥Ñ¥¹¡¦¥í¡¼¥É¤ò¼Â¹Ô¤¹¤ë¾ì¹ç¡¢ÎóÇÛÎó¤Î¹Ô¿ô¤ª¤è¤Ó¥¹¥È¥ê¡¼¥à¡¦¥Ð¥Ã¥Õ¥¡¤Î¥µ¥¤¥º¤ò»ØÄꤹ¤ë¤È¡¢ÆäË͸ú¡£
- ¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Î¥¥ã¥é¥¯¥¿¡¦¥»¥Ã¥È¤ÏCHARACTERSET¤Ç»ØÄê¤Ç¤¤ë
- CHARACTERSET¤Ç»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢NSL_LANG¤¬»ÈÍѤµ¤ì¤ë
INFILE | ¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò»ØÄꤹ¤ë¡£ÆþÎϥǡ¼¥¿¤Ç¤¢¤ëCSV¥Õ¥¡¥¤¥ë¤ä¸ÇÄêĹ¥Õ¥¡¥¤¥ë¡£Ê£¿ô¥Õ¥¡¥¤¥ë¤ò»ØÄꤹ¤ë¤³¤È¤â²Äǽ¡£À©¸æ¥Õ¥¡¥¤¥ëÆâ¤Ë¥Ç¡¼¥¿¤¬¤¢¤ë¾ì¹ç¤Ï¡Ö*¡×¤ò»ØÄê¡£ | SQL*Loader¤ò¼Â¹Ô¤·¤¿¥Ç¥£¥ì¥¯¥È¥ê¤«¤é¤ÎÁêÂХѥ¹¤Ç¥Ç¥£¥ì¥¯¥È¥ê¤ò»ØÄê²Äǽ¡£ |
- ¸ÇÄêĹ¥ì¥³¡¼¥É
- Á´¥ì¥³¡¼¥Én¥Ð¥¤¥ÈŤθÇÄê¥ì¥³¡¼¥É·Á¼°
INFILE datafile_name "fix n"
- ²ÄÊѥ쥳¡¼¥É
- ¥ì¥³¡¼¥ÉĹ¥Õ¥£¡¼¥ë¥É¤Î¥Ð¥¤¥È¿ô¤ò»ØÄê
INFILE "datafile_name" "var n" ... 009hello,cd,010world,im,¤³¤ì¤À¤È1¥ì¥³¡¼¥ÉÌܤϡÖ9ʸ»ú¡×¡¢2¥ì¥³¡¼¥ÉÌܤϡÖ10ʸ»ú¡×
- ¥¹¥È¥ê¡¼¥à¥ì¥³¡¼¥É
- ¥ì¥³¡¼¥É½ªÎ»µ¹æ¤òÆɤ߹þ¤à¤³¤È¤Ç1¥ì¥³¡¼¥É¤È¤¹¤ë
- UNIX¥Ù¡¼¥¹¤Î¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Ç¤Ï¡¢terminator_string¤ò»ØÄꤷ¤Ê¤¤¾ì¹ç¡¢¥Ç¥Õ¥©¥ë¥È¤ÇLFʸ»ú\n¤¬»ÈÍѤµ¤ì¤ë
INFILE datafile_name ["str terminator_string"]
- Àǽ
- ¸ÇÄêĹ > ²ÄÊÑ > ¥¹¥È¥ê¡¼¥à
- ³Æ¥Ç¡¼¥¿¡¦¥Õ¥¡¥¤¥ë¤ËÂФ·¤ÆINFILE¶ç¤ò»ØÄꤹ¤ë
- ¥ì¥³¡¼¥É¤Î¥ì¥¤¥¢¥¦¥È¤ÏƱ¤¸¤Ç¤¢¤ëɬÍפ¬¤¢¤ë
INFILE mydat1.dat BADFILE mydat1.bad DISCARDFILE mydat1.dis INFILE mydat2.dat
BADFILE | ²¿¤é¤«¤Î¥¨¥é¡¼¤¬¤¢¤Ã¤ÆDB¤ËÆþ¤ì¤é¤ì¤Ê¤¤¥Ç¡¼¥¿¤¬¤¢¤Ã¤¿¾ì¹ç¡¢¤½¤Î¥Ç¡¼¥¿¤¬¤³¤Î¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤµ¤ì¤ë¡£ | ÆþÎϥǡ¼¥¿¥Õ¥¡¥¤¥ë¤È¤·¤Æ¤½¤Î¤Þ¤ÞINFILE¤Ç»ØÄê¤Ç¤¤ë |
DISCARDFILE | WHEN¤Ë¤è¤Ã¤Æ¥í¡¼¥ÉÂоݳ°¤È¤Ê¤Ã¤¿ÇÑ´þ¥Ç¡¼¥¿¤¬¡¢¤³¤Î¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤµ¤ì¤ë¡£ |
INSERT | ¿·µ¬¤Ë¥Ç¡¼¥¿¤ò¥í¡¼¥É¤¹¤ë¡£ | ¥í¡¼¥É¤¹¤ëÁ°¤Ëɽ¤ò¶õ¤Ë¤¹¤ëɬÍפ¬¤¢¤ë |
APPEND | ¥Ç¡¼¥¿¤òÄɲ乤롣 | |
REPLACE | ¥Æ¡¼¥Ö¥ë¤ÎÆâÍƤòÁ´¤Æºï½ü¤·¡¢¿·µ¬¤Ë¥Ç¡¼¥¿¤ò¥í¡¼¥É¤¹¤ë¡£ | ºï½ü¤Ï¡¢DELETE¤ËÁêÅö¡£ |
TRUNCATE | ¥Æ¡¼¥Ö¥ë¤ÎÆâÍƤòÁ´¤Æºï½ü¤·¡¢¿·µ¬¤Ë¥Ç¡¼¥¿¤ò¥í¡¼¥É¤¹¤ë¡£ | ºï½ü¤Ï¡¢TRUNCATE¤ËÁêÅö¡£ |
FIELDS TERMINATED BY | ¥Ç¡¼¥¿¤ò¶èÀÚ¤ëʸ»ú¤ò»ØÄê¡£ | |
FIELDS OPTIONALLY ENCLOSED BY | ¥Ç¡¼¥¿¤ò°Ï¤àʸ»ú¤ò»ØÄê¡£°Ï¤Þ¤Ê¤¤¾ì¹ç¤ÏÉÔÍס£ |
- ¥«¥ó¥Þ¶èÀÚ¤ê
- FIELDS TERMINATED BY ","
- ¥¿¥Ö¶èÀÚ¤ê
- FIELDS TERMINATED BY X'09'
- ¤¤¤¯¤Ä¤«¤Î¶õÇò¤ä¥¿¥Ö¶èÀÚ¤ê
- FIELDS TERMINATED BY WHITESPACE
- À©¸æ¥Õ¥¡¥¤¥ë¤ÎÄêµÁ¤Ç»ØÄꤷ¤¿¥Õ¥£¡¼¥ë¥É¤Î¿ô¤¬¡¢¼ÂºÝ¤Ë¥ì¥³¡¼¥ÉÃæ¤Ë¸ºß¤¹¤ë¥Õ¥£¡¼¥ë¥É¤è¤ê¿¤¤¾ì¹ç¡¢»Ä¤ê¤Î¡Ê»ØÄꤵ¤ì¤¿Í¾Ê¬¤Î¡ËÎó¤ËNULLÃͤòÀßÄꤹ¤ë¡£
1.3 * key_storage ¤³¤Î¼°¤Ç¤Ï¡¢¥¡¼µ²±°è¤¬¼¡¤Î¤è¤¦¤ËÄêµÁ¤µ¤ì¤Þ¤¹¡£ key_storage = (number_of_rows) * ( 10 + sum_of_column_sizes + number_of_columns )
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Î¥Õ¥£¡¼¥ë¥É¤¬ºÇÂçŤòĶ¤¨¤Æ¤¤¤Þ¤¹
- SQL*Loader¤Ï¡¢£±¥«¥é¥à256¥Ð¥¤¥È°Ê¾å¤Î¥Ç¡¼¥¿¤òÅÐÏ¿¤·¤è¤¦¤È¤¹¤ë¤È¾åµ¥¨¥é¡¼¤¬µ¯¤¤ë¡£
- ¤È¤¤¤¦¤³¤È¤Ç¡¢³Æ¥«¥é¥àÄêµÁ¤ËCHAR(1000)¤È¤«»ØÄꤹ¤ë
- ²¿¤â¥«¥é¥àÄêµÁ¤ò¤·¤Ê¤¤»þ¤ÏCHAR(255)
- ³°Éôɽ¤ò»È¤¦¤Û¤¦¤¬¤¤¤¤
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ø¤Î¥í¡¼¥É»þ¤Ë¥Ç¡¼¥¿¤òÊÑ´¹¤¹¤ë¾ì¹ç
- Æ©²áŪ¤Ë¥Ñ¥é¥ì¥ë½èÍý¤ò¹Ô¤¦Á°¤Ë¡¢³°Éô¥Ç¡¼¥¿¤òʬ³ä¤¹¤ëɬÍפ¬¤Ê¤¤¾ì¹ç
- SQL*Loader¤ò»È¤Ã¤¿Êý¤¬¤¤¤¤
- ¥ê¥â¡¼¥È¤Ç¥Ç¡¼¥¿¤ò¥í¡¼¥É¤¹¤ë¾ì¹ç
- ¥Ç¡¼¥¿¤ËÂФ·¤ÆÊÑ´¹¤ò¹Ô¤¦É¬Íפ¬¤Ê¤¯¡¢¤½¤Î¥Ç¡¼¥¿¤ò¥Ñ¥é¥ì¥ë¤Ç¥í¡¼¥É¤¹¤ëɬÍפ¬¤Ê¤¤¾ì¹ç
- ¥«¥Æ¥´¥ê¡§
- ¥¤¥ó¥¿¡¼¥Í¥Ã¥È
- ¥Í¥Ã¥È¥µ¡¼¥Ó¥¹
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
gl13Ac Thanks a lot for the blog article.Thanks Again. Much obliged.
SQL*Loader - ���.memo - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� モンクレール アウトレット http://www.pslcbi.com/moncler2014.html
SQL*Loader - ���.memo - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� モンクレール ダウンジャケット 激安 http://www.pslcbi.com/moncler2014.html
Hi friends, how is the whole thing, and what you would like to say on the topic of this article, in my view its genuinely remarkable in favor of me.|
¥µ¥Þ¥ó¥µ¥¥ó¥°¥º http://www.quizverse.com/¥µ¥Þ¥ó¥µ¥¥ó¥°¥º-¥Ð¥Ã¥°-c-15_17.html
J0DgRx <a href="http://apuwspyirnhi.com/">apuwspyirnhi</a>, [url=http://bybfrnqonyxf.com/]bybfrnqonyxf[/url], [link=http://nqptxdluspav.com/]nqptxdluspav[/link], http://cihpyucygcxf.com/