Comparing Files

[acct98]

Does anyone know a simple way to comapre a text file that contains the original records to what was loaded? The reason why I ask is because 2 of of 149,450 records were not loaded to the table and I am trying to find out which records did not load.

 

[rao1soft]

use utlfile package to open your text file; then you can loop through each line (record) and compare with your rows in table or parse for unique key fields.
the other way is output your rows as text in the same format (csv or fixed width) and use any file compare utility.
let us know what worked and how.

 

[karluk]

The best way to discover the errors would be to rerun the load, this time specifying a BADFILE to store the rejected records. Of course this requires that you restart your load from scratch, so hopefully it won't be too time consuming.

 

[acct98]

Karluk,

I did that but i did not receive any errors or any records in the badfile log.

 

[karluk]

Hmm, did you also include a DISCARDFILE?

 

[acct98]

I search for the discardfile and could not find one. I'm trying to create a unique key coming out of the old system and give it another try.