Load the data file name in the column of table using sqlloader
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.
What's wrong with script LK_Brwn provided as an answer to previous post?
It certainly solves question #1
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
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.
Click Here to Expand Forum to Full Width