DSXchange

Hi, I need to do a daily full load for a particular oracle target table, and am using the ORA OCI Load Stage (ie the bulk loader) with Direct Path load. Now, for this to work properly, it seems the target table must already be empty, since the bulk loader stage does not give the option of clearing a...

Thats the problem. That was th efirst thing that came in to my mind but it doesnot work. I ran into the same problem as Deepak today, and I simply did what ray and crouse suggested. SELECT `Table 1`.FirstColumn, `Table 1`.`Second Column` FROM `Table 1`; It worked without any problems. Are you sure ...