Import all csv files into a table oracle
Use a shell loop, instead of trying to pass a wildcard:


#!/bin/bash 
. ~/.bash_profile 
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1

for FILE in /data/SDP/Import/*.csv; do
    sqlldr USERID=user/pass@mydb "DATA=$FILE" \
        CONTROL=/home/path/test.ctl LOG=/home/path/test.log
    done