Loading multiple text files using SQL*Loader

sama · #1 (**permalink**) 09-10-03, 03:37

I load more than one text file using SQL*Loader per day. Loading one file at a time is not a problem but all of them at once proved difficult for me. I am running Windows 2000. Can anyone provide a script that I can use to load all existing text files in say c:\load directory as I am looking forward to scheduling the task at regular intervals. Anyone to help please?

Ida Hoe · #2 (**permalink**) 09-11-03, 11:47

Quote:

Originally posted by sama
I load more than one text file using SQL*Loader per day. Loading one file at a time is not a problem but all of them at once proved difficult for me. I am running Windows 2000. Can anyone provide a script that I can use to load all existing text files in say c:\load directory as I am looking forward to scheduling the task at regular intervals. Anyone to help please?

http://www.databasejournal.com/featu...le.php/1461651

Internet Services

Web Development

Digital Marketing

Consumer Tech