-
How to track the Log information when SQL*Loader loads the data ?
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
SUROOP B
-
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'
-
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
SUROOP B
-
If you want to save the information into a table, I have no suggestions except program by yourself to solve this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|