How to skip a Header record in SQL Loader without modifying control file??

Oracle Apps Interview Questions › Category: SQL Loader › How to skip a Header record in SQL Loader without modifying control file??

0 Vote Up Vote Down

Questions Master asked 10 years ago

can we stop loading of 1st record of data file without modifying control file?

1 Answers

0 Vote Up Vote Down

Shailender Thallam Staff answered 10 years ago

Yes you can skip records of data file by using the same SKIPcommand which we use in the control file by using SKIP keyword as parameter to SQLLDR on the command line.
Below is the syntax:

sqlldr userid=ora_id/ora_passwd control=control_file_name.ctl skip=4