Re: Automatic import of a text file into an Oracle database

If you are using Oracle 9i, then have a look at External Tables. It uses SQL*Loader's engine, but you can access the text file just as if it were a table in the database (READ ONLY). Then you can use SQL statements to verify and move the data.

HTH,
Brian

Lars Mollerup wrote:
>
> Hello folks!
>
> here is my question:
>
> What is the best way to get data from a character delimited text file into
> an oracle database once a day. It should import it automatically and check
> the data before inserting values into tables?
>
> (I am thinking of making a VB program to do this but could it be be done by
> scheduling a
> stored procedure or some other Oracle specific way?)
>
> TIA
>
> Lars Mollerup
> NIVA, Norway

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"