I want to insert multiple file from SQLLOADER into one table .
But I want to use only one INFILE parameter in controlfile.
How can I insert file list with use of "INFILE".
Can I use directory name in INFILE ?
Printable View
I want to insert multiple file from SQLLOADER into one table .
But I want to use only one INFILE parameter in controlfile.
How can I insert file list with use of "INFILE".
Can I use directory name in INFILE ?
Well if you are doing this with bash then you can do the following.
Code:ls data*.dat | while read line ; do
sqlldr file $line control sql.ctl
done