load.ctl
Load DATA
INFILE 'C:\sqlload\loaddata.txt'
INTO TABLE tb_sql_load_test
FIELDS TERMINATED BY "|"
( STATIS_DATE ,
PROVCODE,
FILE_PATH,
FILE_NAME
)
loaddata.txt
20100722|01|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
20100722|01|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
20100722|01|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
20100723|02|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
20100723|02|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
20100723|02|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
20100723|02|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
20100723|02|/home/monitor/sas/data/baobiao/ftp/139mail_actiondata/gd/201007/A/139mail_01_2508644_Action_20100721.Z|139mail_01_2508644_Action_20100721.Z
执行sqlload
c:\>sqlldr control='c:\sqlload\load.ctl' log='c:\sqlload\load.log'
阅读(2445) | 评论(0) | 转发(0) |
