Life is a journey

Who Dares Wins
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

Oracle SQL Loader Command

Posted on 2009-01-07 11:48  zhaobin  阅读(251)  评论(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.