Automatically load data from txt files into database
i want to create a script which should be able to copy the data from txt/xml files into database using sql loader utility or external tables options. and i also want to add this script into the DBMS_JOB package so that this script should run automatically after every 6 hours and copy the data from txt/xml files into database or if their is any other option to run this script do let me know?
Can anyone guide me how to create a script to process this job or if u have a sample script send it to me.
Click Here to Expand Forum to Full Width