Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic import of a text file into an Oracle database
With later versions of Oracle you can map a character file directly to an
Oracle table
(this is known as External Tables ) and you could then write a procedure or
other code to validate it and transfer it to whicheve tables you require.
Go to http://tahiti.oracle.com and search for External Tables
"Lars Mollerup" <lars.mollerup_at_niva.no> wrote in message
news:bcn45r$8di$1_at_dolly.uninett.no...
> 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
>
>
Received on Tue Jun 17 2003 - 10:00:32 CDT