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 -> Automated text file import

Automated text file import

From: Randy Harris <randy_at_SpamFree.com>
Date: Mon, 28 Mar 2005 04:57:08 GMT
Message-ID: <D8M1e.15299$DW.8123@newssvr17.news.prodigy.com>


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.

-- 
Randy Harris
(tech at promail dot com)
Received on Sun Mar 27 2005 - 22:57:08 CST

Original text of this message

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