santhoshreddy, July 26, 2017 - 5:55 am UTC
But when i run sql loader from windows command prompt,the data loaded, but not when i call from shell script.
if that issue due to case preserve then how data loaded from Command prompt (i used same control file 2 times, and i did not make any changes)?
July 27, 2017 - 1:15 am UTC
Here's a tip...
Show us the entire control file, the shell script you're using AND the log file AND the output...
We're flying blind here