This content has been marked as final. Show 3 replies
When you try to load the data and if the data is not in valid state, then it doesn't load all the records. It only inserts the records that are valid. Check your records.
If you want to test try to create some test table and load.
Could you please help me out steps for inserting CSV column vlaues into Apex database Table.
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!