This content has been marked as final. Show 3 replies
Re: Ramesh's suggestion.
If you go to SQL Workshop > Utilities > Data Workshop >Text Data Load > Repository, there is an entry for each data load. The tenth column from the left is Failed and if the count there is non-zero, it will be underlined to indicate a link to the error messages generated. Click on the number. The error message display will open. All to often, when I do a load, I see something like:
ORA-01722: invalid number Row 1: May your memories be of joyous times,
In this example, I was trying to load character data but it was going to a numeric primary key column.
Hope this helps!