Life is a journey

Who Dares Wins
posts - 26, comments - 2, trackbacks - 0, articles - 0
  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理

Oracle SQL Loader Command

Posted on 2009-01-07 11:48 zhaobin 阅读(68) 评论(0) 编辑 收藏

sqlldr control=StaticData/t_prod.ctl, log=BuildScript/log/t_prod.log, bad=BuildScript/log/badz_t_prod.log, data=StaticData/T_PROD.CSV userid=username/password@cpsdemo

To specify the maximum number of errors allowed:

add     ERRORS=9999

The default value is 50.