Chinaunix首页 | 论坛 | 博客
  • 博客访问: 5208376
  • 博文数量: 1004
  • 博客积分: 8199
  • 博客等级: 中将
  • 技术积分: 13042
  • 用 户 组: 普通用户
  • 注册时间: 2010-05-25 20:19
个人简介

脚踏实地、勇往直前!

文章分类

全部博文(1004)

文章存档

2020年(1)

2019年(93)

2018年(208)

2017年(81)

2016年(49)

2015年(50)

2014年(170)

2013年(52)

2012年(177)

2011年(93)

2010年(30)

分类: Oracle

2010-07-23 09:56:29

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 userid=hxl/hxl@orcl control='c:\sqlload\load.ctl' log='c:\sqlload\load.log'
阅读(1668) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~