Is it possible to generate SQL Loader control files (.ctl) for multiple tables, in one run?
It is possible to generate control files for multiple tables in one go by following the steps below:
1. Open the Schema Browser.
2. Highlight the tables you require (Shift or Ctrl to multi-select).
3. Right click on the highlighted tables.
4. Choose 'Save As'.
In the new window which appears, choose in the dropdown menu 'SQL Loader', select a directory to save into, and when you press OK, Toad will generate the control files for each of the highlighted tables.
