If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Load the data file name in the column of table using sqlloader

Hi,
I have set of files in a folder, all the data present in these files should be loaded in the oracle database through sql loader. The no of files present in that folder may change day by day. I have two problems.
1. All the files should be loaded into the database without specifying the file name in the control file. (dynamically the filename should change).
2. The data file name should be loaded in the column of the table along with the data.
Kindly give me any suggestions for this. Prefarably any unix shell script.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.