How to track the Log information when SQL*Loader loads the data ?
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.
Dat File name : XYZ.dat
Date Loaded :Sysdate
All these information I need to update in a Oracle database when ever a load takes place.
These fields are to be updated.Pls help me guys with your suggestions and the scripts if possible.
Thanks in Advance
You can specify the discard file,log file and bad file in sqlldr command line.
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'
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.
If you want to save the information into a table, I have no suggestions except program by yourself to solve this.
Click Here to Expand Forum to Full Width