Make a batch file suppose load_data.bat
–content of the file is
–you keep the batch and controlfile in the same folder where the datafiles are there.
–This script will upload all data files within the same folder whatever fortmat they have
for %%f in (*.*) do ( echo %%f sqlldr user_name/passwrd Control = allfileloc.ctl data= %%f )
—allfileloc.ctl file contents are below
—suppose column names are colm01..column10, change it according to your column names
load data CHARACTERSET UTF8 append into table scott.emp fields terminated by "~" trailing nullcols ( colm01, colm02, colm03, colm04, colm05, colm06, colm07, colm08, colm09, colm10 )