We are trying to perform a bulk copy from Oracle to MS SQL using Javelin. We have successfully copied ~14K records in about 6 seconds. However, when attempting to perform a complete bulk copy (~156 million) record, it failed (freezes) for over a day and crashed.
Anyone has any clue why is this happening? I don't want to have to create thousands of subsets to copy.
FYI, there are only 9 columns in the table.