You could use one of the Oracle Precompilers or the PL/SQL file I/O built-in package UTL_FILE to read the file and then perform inserts into the appropriate table. SQL*Loader is probably easiest unless you want to do some pretty complicated data cleansing etc.
If you are looking for spped will inserting I would use Pro*C.
Also use temporary tables to store the data and have a second job load it onto the relevant tables on the database. Or if you have no manipluation to do just insert it in your Pro*C job
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.