DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

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

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    38

    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

  2. #2
    Join Date
    Mar 2004
    Posts
    8
    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'

  3. #3
    Join Date
    Mar 2002
    Posts
    38
    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

  4. #4
    Join Date
    Mar 2004
    Posts
    8
    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
  •  


Click Here to Expand Forum to Full Width