sql loader script

Shell Programming and Scripting
1

hi all

i am new to shell scripting.

i have 35 flat files delimited files that i have to load in to a table.

i was asked to create a shell script that loads the data into the table...

could you please help me if you have a script.

Also .. how to create logs files...does my sql loader create log files for me?

regards
raj

2

What database software are we talking about here, mysql, Oracle?

3

hi tony sorry i missed that

am using oracle 11g

i get max of 35 files.....daily
some days i can get 10, 11, 2 , 35 files etc

but max 35 files

i need to write a single unix shell script that uses sql loader to load them in to a single table... all the files have the same structure

regards
raj

4

Since all data file have the same exact structure, you may want to concatenate them together into a single data file, and use this one to load data.

You will have to create a SQL*Loader control file (only once, initially). Check the Oracle documentation for the same:

SQL*Loader Control File Reference

If you have atleast an Oracle client installed in your Unix/Linux box, and all environment variables are set properly, then you can run "sqlldr" from the command line. Yes, it does create a log file for you.

Hope that helps,
tyler_durden

____________________________________________________
"Only after disaster can we be resurrected."