On unix I'd do this as follows :


for file in $(ls *.dat); do
sqlldr username/[Email Address Removed] \
data=/loadcdr/$file log=/loadcdr/log/${file}.log
bad=/loadcdr/bad/${file}.bad \
discard=/loadcdr/discard/${file}.dis etc. etc.
done

Hans

-----Original Message-----
From: Sudhanshu Shekhar1
[mailto:oracledba-ezmlmshield-x59980990.[Email address protected]
Sent: dinsdag 3 april 2007 9:46
To: LazyDBA Discussion
Subject: SQL Loader Problem in Linux


Dear Team,

Please help i am facing the following problem.

In windows the below comands are executed, what changes are to be done
for Linux Envoirement. Moto is to Execute Multiple .dat file through sql
Loader using common ctl file


echo on
for %%f in (*.dat) do (
sqlldr username/[Email Address Removed] log=d:\loadcdr\log\%%f.log
bad=d:\loadcdr\bad\%%f.bad discard=d:\loadcdr\discard\%%f.dis
errors=20000 move %%f d:\cdrout\)






Thanks & regards,

Sudhanshu Shekhar
IBM India Pvt.Ltd.
+91 99370 02535
[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page