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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Automated text file import

Re: Automated text file import

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 27 Mar 2005 22:08:33 -0800
Message-ID: <1111989900.382621@yasure>


Randy Harris wrote:
> I need to set up an automated import of text files into Oracle 8.1.7.4 on
> HP-UX, am looking for advice.
>
> Logic flow would look something like:
>
> On a periodic basis:
> Examine a directory for files (names not know in advance)
> Iterate through any found files:
> Import contents into a table
> Delete the file
>
> Can this be done from within Oracle, or does it need to be set up as a
> "push" from the OS? Any suggestions appreciated.

You'll need to use code external to the database unless you upgrade to a currently supported version of the database: 10g.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Mar 28 2005 - 00:08:33 CST

Original text of this message

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