oracle的sqlload导入详解

1.执行脚步:

sqlldr user/password@database control=filename.ctl data=filename.txt errors=500000 rows=500000 log=filename.log bad=filename.bad direct=true

2.ctl文件写法:

LOAD DATA APPEND INTO TABLE 表名 FIELDS TERMINATED BY '|' (

字段,

字段,

....

)

3.data文件类型

值1|值2|值3|