I am loading data from text file into a table through unix script.
My requirement is that, there are about 200 files in a folder, these data file name should be loaded into the target table. The content of the data file doesn't have the file name. I have done the following steps.
export data_file
for data_file in `ls BBT_SHAW*.txt`; do
sqlldr userid=dwh_user/dwh_user@dwh control=bbt_shaw1.ctl data=$data_file
done
the control file is been attached in the attachment.
When i execute this i am getting the below error.
SQL*Loader-951: Error calling once/load initialization
ORA-02373: Error parsing insert statement for table DWH_USER.BBT_SHAW1.
ORA-00911: invalid character
Can any one solve this issue.