-
Dear DBA's
I require your advise regarding running SQL*LOADER continuecely for multiple Tables. I have have created seprate Control file, Datafile for each table. now this I want to insert into Oracle through SQL*LOADER for that I do
SQLLDR userid=USERNAME/PASS@DB DIRECT=TRUE control=TABLENAME.CTL log=TABLENAME.LOG ERRORS=10000000
this works properly. But every time I have to execute this command line by changing different TABLENAME control file and log file. So every time there will be login. Can I avoid this and execute SQLLDR only once for all controlfiles. Please Help.
Thanks & Regards
Shailesh
-
As far I know its not possible, but you can create different loader scripts and trigger them on specified time using cron (on Unix) or at (on NT).
-
We use a script file contents the loader :
/dw1/createdb/sql/loader/ldr/dwstt_store_type.ldr
/dw1/createdb/sql/loader/ldr/dwbyg_buy_grp.ldr
/dw1/createdb/sql/loader/ldr/dwbng_banner_grp.ldr
/dw1/createdb/sql/loader/ldr/dwcus_cust_mst.ldr
where /dw1/createdb/sql/loader/ldr/dwcus_cust_mst.ldr
is:
sqlldr dwdba/dwdba control=/dw1/createdb/sql/loader/ctl/dwcus_cust_mst.ctl error
s=999999 direct=false log=/dw1/createdb/sql/loader/logs/dwcus_cust_mst.log disca
rd=/dw1/createdb/sql/loader/logs/dwcus_cust_mst.log
and /dw1/createdb/sql/loader/ldr/dwbng_banner_grp.ldr is:
sqlldr dwdba/dwdba control=/dw1/createdb/sql/loader/ctl/dwbng_banner_grp.ctl dir
ect=false errors=999999 log=/dw1/createdb/sql/loader/logs/dwbng_banner_grp.log
discard=/dw1/createdb/sql/loader/logs/dwbng_banner_grp.discard
hope this will help you.
