Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a client who has a requirement that I load data from csv files into an Oracle database. Part of the requirement is that I use sqlldr and provide a control file to facilitate loading this data. However there are a lot of text files with a lot of fields, and it will be a lot of labor to create the tables in the database and then create the control file for each table.

I know there are tools which will read a bunch of text files and generate the SQL that is required to create all the tables and load them with data. But that does not involve sqlldr with control file, which is the requirement. Is there a way to do this easily?

share|improve this question
    
Just a note to say that SQL*Loader is considered obsolete; the modern way to do this is with external tables. –  Gaius Dec 14 '11 at 10:25

1 Answer 1

The Utilities manual that describes SQL*Loader syntax (which no sane person can recall anyway!) has a number of case studies (doc link here). Case study 5 covers loading into multiple tables. The actual case studies are installed into $ORACLE_HOME/rdbms/demo if you choose to install the companion CD. I seem to recall that in earlier versions they were also described in full in the Utilities manual.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.