Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic import of a text file into an Oracle database

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

From: konsultant_1 - konsultancIT.pl <konsultant_1_at_konsultancIT.pl>
Date: Tue, 17 Jun 2003 15:19:53 +0200
Message-ID: <3EEF1579.6000203@konsultancIT.pl>


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
>
>

SQLOADER

-- 

   www.konsultancIT.pl
Oracle&MS-SQL consulting
Received on Tue Jun 17 2003 - 08:19:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US