SQL*Loader in shellscript

Hi,

what is the ideal format of the file to load it into oracle table by using SQL*LOADER. The file contains six columns and the oracle table contains 15 columns. Is there any criteria that columns should be equal in no.?

Can anyone help me on this, i need to use this in my shell script?

Thanks in advance.

Regards,
Venkat.

You specify the format of the input data using a sqlldr control (ctl) file. Assuming that having six fields does not violate table constraints, then this will work just fine.

read about ctl files here:SQL Loader Utility

Thanks a lot for the information... nice manual...