After importing data from one ODBC datasource to Oracle (10g) and seeing that all the records were successfully loaded, I went to query the records and none was imported. I set the "COMMIT EVERY " to 100, the default. Any one has the same problem and solution to it. Thanks.