#!/usr/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export PATH=$PATH:$ORACLE_HOME/bin
#
#-- let this be your data_dir
#
DATADIR=/home/oracle/scr/ora/dir_for_sqlldr
clear
# idea is to browse through all the files (input files)
# in the directory , pick the name of the files
# pass it as input parameter to the sqlldr.
# sqlldr control file need to be generated like this for every load.
# if multiple files need to be loaded into same table, it can be done
# You can also use a simple perl or sed script to generate a controlfile.
# So all the files in DATADIR is loaded.
# after every load u need to move the file that is loaded to somewhere.
# for your second issue, if the TABLE_NAME and input FILENAME can 
# be standardised(have the same NAME based on some dateformat,
# its going to be a lot easier.
find $DATADIR/* | while read INFILE
do
echo load data                                    > /tmp/temp1.ctl
echo infile "'$INFILE'"                         >> /tmp/temp1.ctl
echo append into table member                 >> /tmp/temp1.ctl
echo fields terminated by ',' trailing nullcols  >> /tmp/temp1.ctl
echo (name,                                     >> /tmp/temp1.ctl
echo address)                                    >> /tmp/temp1.ctl
echo
echo invoking the sql*loader
echo using table $INFILE
sqlldr userid=mag/mag control=/tmp/temp1.ctl
echo "****************************************************************"
# You can now move your used $INFILE to somewhere..
done

----------------------------------------------------------------------

this is a sample session output of above script
anotherfile.dat has NO records in it.

----------------------------------------------------------------------

invoking the sql*loader
using table /home/oracle/scr/ora/dir_for_sqlldr/anotherfile.dat

SQL*Loader: Release 9.2.0.4.0 - Production on Thu Sep 16 11:38:05 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

****************************************************************

invoking the sql*loader
using table /home/oracle/scr/ora/dir_for_sqlldr/member.dat

SQL*Loader: Release 9.2.0.4.0 - Production on Thu Sep 16 11:38:06 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 4
****************************************************************