How to parse a 300000 line text file into Oracle 8 ?

From: <rock_cogar_at_my-deja.com>
Date: Wed, 24 Nov 1999 16:04:35 GMT
Message-ID: <81h2af$v96$1@nnrp1.deja.com>

I need advise on what is a really good method to parse 847 variable length records (delimited by tag "FIMAGE:") from a 305,000 line text file into a simple Oracle 8.1.5 table made up of various long and varchar2 columns. I am running on NT 4.0, sp5.

While I could do this task using PowerBuilder's PowerScript, PL/SQL with package UTL_FILE or even Visual C++, I am not sure if any of these methods will be quick enough.

Any Ideas ?

If this is not bad enough, there 8 other text files to parse that are up to 2.4 million lines long !

Thanks,
Rock Cogar
Radian International, LLC.
Oak Ridge, TN. USA.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 10:04:35 CST