futureDBA
asked on
Oracle: Automatic import of data into table
I am wondering if there is a way to automatically import data from a csv file into a table based on a schedule
in a directory on the same system that oracle is installed on, csv files will be dropped on a daily basis based on tablename and date
so /home/oracle/import may have a new file dropped in everyday
called
import080812.csv for august 8th
import080912.csv for august 9th
import081012.csv for august 10th
these files conform with the data structure and i never have a problem importing these manually.
how can i go about not having to do this manually, i just want them imported in automatically every day at 12pm
in a directory on the same system that oracle is installed on, csv files will be dropped on a daily basis based on tablename and date
so /home/oracle/import may have a new file dropped in everyday
called
import080812.csv for august 8th
import080912.csv for august 9th
import081012.csv for august 10th
these files conform with the data structure and i never have a problem importing these manually.
how can i go about not having to do this manually, i just want them imported in automatically every day at 12pm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree with slobaray.
sqlloader is just a external table with an extra step
if you already have a script available that uses sqlloader then by all means reuse it.
If you have to construct a control file and a script to invoke it, just use an external table. Same syntax, but no need for anything external to the database except the csv files themselves
if you already have a script available that uses sqlloader then by all means reuse it.
If you have to construct a control file and a script to invoke it, just use an external table. Same syntax, but no need for anything external to the database except the csv files themselves
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I too agree with sdstuber suggestion.
ASKER
i am going to try sdstuber and slightwv suggestions and go with what ever ends up being the best solution for my environment
ASKER
revisiting this question after a couple of months because this has become my number one priority with a project i am currently working on..
sdstuber, can you point me towards some documentation on your method / examples / or elaborate a bit more please?
sdstuber, can you point me towards some documentation on your method / examples / or elaborate a bit more please?
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.