txt µ¼Èë oracleµÄÎÊÌâ
550016~"34jh4"~"0324100123000276"~"01"~"123456ÍÅ ÒÔÉÏÊÇÎı¾µ¼ÈëÊý¾Ý ²»Òª·ûºÅ ¿ØÖÆÎļþ load data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ infile 'ddd.txt'¡¡¡¡¡¡¡¡¡¡¡¡ append into table DDST_download_comdeta¡¡ ( q, terminated by "~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ~"Ϊ½áβ°¡ £© w, terminated by ""~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ"~"Ϊ½áβ°¡ £© e, terminated by ""~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ"~"Ϊ½áβ°¡ £© c, terminated by ""~"" (ÎÊÌâËùÔÚ£¬Ôõôд²ÅÒÔ"~"Ϊ½áβ°¡ £© v, terminated by £¨Õâ¸öÔõôд£© f char "123") /*×îºófµÄÖµÏëÒª¸³ÉÏͳһµÄÌØÊâÖµÔõôд*/ ÒÔÉ϶¼ÊDz»³É¹¦µÄ³¢ÊÔ ÂÒдµÄ
ÒýÓà ÄãÏÈÓÃÎı¾´ò¿ªÕâ¸öÎļþ,Îı¾Ìæ»»¹¦ÄÜ"~"Ìæ»»³É, È»ºóµ¼Èë Ì«¸ÐлÀ² ÎÒ¾ÐÄàÓÚÄǸö¸ñʽµÄÎÊÌâ ÄúµÄ»Ø´ðÕæÊÇÈÃÎÒëɪ¶Ù¿ª°¡
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......