Re: how do most people import external data???

John Matzen wrote:
>
> i'm importing web server logs into an orcale database.
>
> Right now, I'm piping the log data into a Perl script that converts
> the file into a bunch of 'INSERT INTO' lines which I then pipe into
> SQL*DBA.
>
> This process is slow...I suspect that the file I'm tyring to import
> right now will be still doing so when I get back in to the office
> Monday morning.
>
> Whats the fatest way to do this?

Instead of creating a flat file of INSERT statements, try creating a fixed-format or delimited ASCII file, and use the Oracle Data Loader to actually load the data into Oracle.

        Bruce

-- 
Bruce MacDonald                           
(Bruce_MacDonald_at_mindlink.net)
Database Consultant
Cornerstone Computer Associates Inc.
Chairperson, Vancouver Oracle Users Group