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