SQL*Loader Control File Generator

[pmarden]

Does anyone know of a SQL*Loader Control File generator which is available for download.

I'm particularly lazy and can't be bothered to write the control files everytime I get a new flat file to load. I'd like to point the code generator to the flat file & recieving table and make it generate the correct control file.

Any ideas?

 

[carp]

Well, the problem is that your flat file will have to have a description of how the data is laid out so that the sql loader control file generator would know how to map the flat data into the target table. Which means....you would have to write a control file for the control file generator so that you wouldn't have to go through the trouble of writing a control file for SQL Loader.

 

[loren256]

Flat files come in a few pretty standard flavors as far as data layout is concerned. why don't you archive your control files as you write them with descriptive names that describe the data layout of the flat file and then reuse them with a little editing? After a few repititions you will have a library of control files that you can reuse efficiently.

You may get some ideas from the case studies at:

http://technet.oracle.com/doc/server.815/a67792/ch04.htm

Are you really particularly lazy or do you just strive to be efficient?

Lazy = disgusting attribute for DBA - get fired soon.

Driven to efficiency = very pleasing attribute for DBA - have job longevity.