Toad World® Forums

Export Dataset in SQL Loader format

1.  It would be nice if the Export Dataset in SQL Loader format provided a method to specify TRAILING NULLCOLS, as my imports often fail with a suggestion to include this. 

2.  Sometimes it is necessary to edit the .ctl file produced by this process.  It would be nice if the process produced a separate .ctl file and .dat file so that you wouldn't need to edit a large file containing both the control info and the data when you wanted to tweak the control info.

3. It would be nice if the control file produced by this problem could be sensitive to the length of large text fields, as imports often fail because of sqlldr assumption of 256 char max.  It shouldn't be necessary to edit the control file to fix this as all the info is known.