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

Oracle Apps Interview QuestionsCategory: SQL LoaderHow to skip a Header record in SQL Loader without modifying control file??
Questions Master asked 4 years ago

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

1 Answers
Shailender Thallam Staff answered 4 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