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

From: <michael_bialik_at_my-deja.com>
Date: Wed, 24 Nov 1999 21:42:01 GMT
Message-ID: <81hm38$eh8$1@nnrp1.deja.com>

Hi.

Is it possible to use SQLLoader?
If not - use either PL/SQL ( make a good usage of BULK BIND ) or C ( use array processing ).
Somewhere I read that with 8i it's possible to call SQLLoader API's from C.

HTH. Michael.

In article <81h2af$v96$1_at_nnrp1.deja.com>, rock_cogar_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 15:42:01 CST