=========================================
用sqlldr将文本导入oracle,好好参考喽 :)
=========================================控制文件p.ctl的内容如下:p.ctl
------------------------------------------
LOAD DATA
INFILE 'f:\data.txt'
APPEND INTO TABLE Test01 FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(hiredate DATE "yyyy-mm-dd hh24:mi:ss",sales)-- create table Test01(hiredate date,sales date)
data.txt文件的内容如下:
------------------------------------------
2004-12-13 07:56:58,2004-12-13 07:59:10
2004-12-13 07:58:24,2004-12-13 08:00:56
------------------------------------------
c:>sqlldr system/root@crm control=f:\p.ctlsql>host sqlldr system/root@crm control=f:\p.ctl
test.ctl:load data
infile 'c:/test.csv'
into table test
fields terminated by ','OPTIONALLY ENCLOSED BY '"'
(时间 date "yyyy-mm-dd hh24:mi:ss",
状态
)
13:49:58 SQL> host sqlldr temp/temp control=f:\test.ctl13:50:21 SQL> select * from test;时间 状态
---------- ----------
2004-10-01 yes
2004-10-01 yes
2004-10-01 no已用时间: 00: 00: 00.15
13:50:27 SQL>
SQLLDR username/password@tns_name CONTROL=c:\temp\discount.ctl LOG=c:\temp\discount.log
DATA=c:\temp\discount.txt BAD=c:\temp\discount.bad ERRORS=100000
用sqlldr做数据导入的时候,有的列用空值?
----------------------------------------
load data
infile 'result.csv'
into table resultxt
fields terminated by ','
TRAILING NULLCOLS
(resultid,
website,
ipport,
status)
用sqlldr将文本导入oracle,好好参考喽 :)
=========================================控制文件p.ctl的内容如下:p.ctl
------------------------------------------
LOAD DATA
INFILE 'f:\data.txt'
APPEND INTO TABLE Test01 FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(hiredate DATE "yyyy-mm-dd hh24:mi:ss",sales)-- create table Test01(hiredate date,sales date)
data.txt文件的内容如下:
------------------------------------------
2004-12-13 07:56:58,2004-12-13 07:59:10
2004-12-13 07:58:24,2004-12-13 08:00:56
------------------------------------------
c:>sqlldr system/root@crm control=f:\p.ctlsql>host sqlldr system/root@crm control=f:\p.ctl
test.ctl:load data
infile 'c:/test.csv'
into table test
fields terminated by ','OPTIONALLY ENCLOSED BY '"'
(时间 date "yyyy-mm-dd hh24:mi:ss",
状态
)
13:49:58 SQL> host sqlldr temp/temp control=f:\test.ctl13:50:21 SQL> select * from test;时间 状态
---------- ----------
2004-10-01 yes
2004-10-01 yes
2004-10-01 no已用时间: 00: 00: 00.15
13:50:27 SQL>
SQLLDR username/password@tns_name CONTROL=c:\temp\discount.ctl LOG=c:\temp\discount.log
DATA=c:\temp\discount.txt BAD=c:\temp\discount.bad ERRORS=100000
用sqlldr做数据导入的时候,有的列用空值?
----------------------------------------
load data
infile 'result.csv'
into table resultxt
fields terminated by ','
TRAILING NULLCOLS
(resultid,
website,
ipport,
status)
解决方案 »
- Oracel 列排序
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP的问题.
- 在程序发布的时候 有什么文件可以替代Oracle客户端的安装
- 如何删除同时多张表?
- 我查不到记录了,但数据库中确实是有记录的
- windows下用jdbc应用程序不能访问另一台windows上oracle8 服务器的问题
- FLASHBACK中的一个问题~
- sequence--伪值
- 表的主键都丢失,image类型向long draw类型转换的错误!
- 用sql语句能否判断出:一整形变量是否在数字组成的字符串中(逗号分隔)?
- 请给我解释一下这条创建用户的语句,谢谢!
- 在线问一简单SQL排序问题,希高手指点
搜索这个 Oracle数据导入工具 V2.0