hi dear friends,
I am brand new to MSDOS and i found that this PLACE is the best place to post ONES query to get quick and optimal suggestions. so here it goes.. thanks all in advance
i have 70 TABLES in oracle and my system is windows XP. unfortunately we have no access to unix.
i need to run sqlldr at the command prompt to load all the 70 tables.
Is there any way i can possibly automate this?
my requirement is that i should not write the sqlldr command manually every time [70 times can u blv it?? phew! ]
can we call a file containing all these commands or something?
Awaiting your response.. thanks a lotI am rusty with the commands necessary to show you exactly by example, but I have written batch files to process MYSQL instructions. You will have to create a single batch file with each command line in it of the 70 tables. Then you can either LAUNCH it from say your XP computer manually, or if its a daily process such as to clear tables for new data to be populated in them such as a P.O.S system etc, you can add the batch file to scheduled task of Windows XP Pro and have it trigger as needed in a manner that is almost set it and forget it.