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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 24 Nov 1999 20:33:51 +0800
Message-ID: <383BDB2F.3F74@yahoo.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.

SQL Loader, especially in 8i, has a good level of flexibility at handling "exotic" files - plenty of detail in the Server Utilities manual.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 24 1999 - 06:33:51 CST