Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Automated text file import
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
![]() |
![]() |