automated script to load files
636380May 12 2008 — edited May 12 2008Hi ,
i have a procudure (pl/Sql) that loads a dat files to oracle tables, taking a file name as input parameter.
i manually execute this pl/sql on daily basis which usually takes 30 min for one file.
but now due to some issue in data i will have to truncate all the tables this procudes load as reload the data,there are nearly 100 files which i have to run,
the files should be processed one after the other in a order.
can any one suggest how can i automate this process.
i just wanna load 10 files at a time.
Meaning, a script to supply files names to this pl/sql and return the log
thanks.