How to track the Log information when SQL*Loader loads the data ?

[bsuroop]

Hi Guys,
I need to track the log/audit information when ever the SQL*Loader loads the data into the Oracle database.

For Instance, my dat file consists of 100 records.
Total Records:100
Dat File name : XYZ.dat
Date Loaded :Sysdate
Table Name:Emp
Records Rejected:20
Status :Fail

All these information I need to update in a Oracle database when ever a load takes place.

Logtable
--------
TotalRecords,
TableName,
FileName,
DateLoaded,
Totalrecords Rejected,
Status

These fields are to be updated.Pls help me guys with your suggestions and the scripts if possible.

Thanks in Advance

Kishan

[adonis]

You can specify the discard file,log file and bad file in sqlldr command line.
e.g.
sqlldr userid=ebills_run_zonghang/ebills@GFBANK control='D:\SL\a.ctl' log='D:\SL\a.log' bad='D:\SL\a.bad' discard='D:\SL\a.dis'

[bsuroop]

Hi adonis,
My requirement is the details of information in the log file to be stored in the logtable whenever an load process has been executed.
Pls let me know more about this.

Thanks
Kishan

[adonis]

If you want to save the information into a table, I have no suggestions except program by yourself to solve this.