-- The format for executing this file with SQL Loader is:
-- SQLLDR control=<filename> log=<logFileName> bad=<badFileName> data=<dataFileName>
-- Be sure to substitute yourversion of SQL Loader and The filename for this file.
LOAD DATA
INTO TABLE TABLE111
REPLACE
FIELDS TERMINATED BY x'09'
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
COL1 CHAR NULLIF (COL1=BLANKS),
COL2 DATE "YYYY/MM/DD" NULLIF (COL2=BLANKS),
COL3 DECIMAL EXTERNAL NULLIF (COL3=BLANKS)
)
注意:COL1 是字段名,不能为YEAR等保留字
Load DATA
INTO TABLE TABLE222
REPLACE
(
COL1 POSITION(01:09) CHAR,
COL2 POSITION(10:19) DECIMAL EXTERNAL
)
执行的时候,使用下面的命令:
cmd.exe /c start sqlldr sqadbuser/sqadbuser@sqa control=C:/SQA/sample.ctl log=C:/SQA/sample.log bad=C:/SQA/sample.bad data=C:/SQA/MASTER/sample.tsv skip=1 rows=5000
在执行的时候,最初没有前面的cmd.exe /c start 的时候
数据有1000多条,只导入了360条程序就“挂”那儿了
加上cmd.exe /c start ,ok了,------这时是另外启动一个dos窗口
另外,commit point的意思也要调查