The SQL Loader log file … as data

Learning is not a spectator sport

I had an interesting AskTom question recently where the poster was using SQL Loader to load in tables, but wanted to be able to analyze the resultant log file after execution.  And of course, what better way to analyze..well…anything…than with a database and some SQL.

So we need to be able to access the log file as a table, and an external table is perfect for that, so let’s start there.

Here’s a sample SQL Loader log file (with a little perturbation to preserve anonymity).  It’s quite complex because multiple tables were loaded as part of a single SQL Loader run.

 Table SCOTT.T1: 222455 Rows successfully loaded. 0 Rows not loaded due to data errors. 1229074 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Table SCOTT.T2: 202547 Rows successfully loaded. 0 Rows not loaded due to data errors. 1248982 Rows…

View original post 1,322 more words

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s