sql loader help [message #517080] |
Fri, 22 July 2011 06:47 |
sathik
Messages: 196 Registered: August 2009 Location: INDIA
|
Senior Member |
|
|
Hi,
I have 780(12*65) csv files generated from 65 databases.
Now I have to load this 780 csv files into 12 tables created in my database for some monitoring and reporting purpose.
to call the sql loader I am plannig to create 780 lines like below.
sqlldr abc@tns/pwd control='E:\html\ctl\html_broken_jobs_rpt.ctl' log='E:\htmlreport\log\html_broken_jobs_rpt.log'
sqlldr abc@tns/pwd control='E:\html\ctl\html_db_size_rpt.ctl' log='E:\htmlreport\log\html_db_size_rpt.log'
sqlldr abc@tns/pwd control='E:\html\ctl\html_fragmentation_rpt.ctl' log='E:\htmlreport\log\html_fragmentation_rpt.log'
sqlldr abc@tns/pwd control='E:\html\ctl\html_index_stats_rpt.ctl' log='E:\htmlreport\log\html_index_stats_rpt.log'
sqlldr abc@tns/pwd control='E:\html\ctl\html_invalid_object_rpt.ctl' log='E:\htmlreport\log\html_invalid_object_rpt.log'
sqlldr abc@tns/pwd control='E:\html\ctl\html_long_running_queries_rpt.ctl' log='E:\htmlreport\log\html_long_running_queries_rpt.log'
.
.
.
we know creating 780 control files is the difficult task.
So I have created only 12 control files. is there any mechanism to pass a varible (planning to declare it in the sqlldr line) to the infile clause like below in sql loader?
infile "E:\htmlreport\output\&a_html_broken_jobs_rpt.csv"
here a is the variable name. it will change every 12 csv files once.
or
is there anyother way to achive this?
[Updated on: Fri, 22 July 2011 06:51] Report message to a moderator
|
|
|