Importing IIS 4.0 logs to Oracle

From: <bezdomny_at_my-deja.com>
Date: 2000/07/10
Message-ID: <8kdd3i$8hf$1@nnrp1.deja.com>#1/1

Does anyone have any experience importing IIS 4.0 extended logs to Oracle. I have tried to use sqlldr into an 8i database but the log files have no real delimiter except for white space and the column widths are variable. I get into trouble when sqlldr hits a line that doesn't contain a "column" (such as, sometimes the Referring URL is absent) and the data gets inserted into the wrong database column.

Can anyone help?

TIA, Bob

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 10 2000 - 00:00:00 CDT