Can you let me know what the purpose of the WHERE clause is in the destination table?

Couple of more suggestions:

1. In your Oracle ODBC DSN, disable LOBs if you're not using them.

2. In your Oracle ODBC DSN, increase the Prefetch Count (memory permitting)

3. Consider dumping the recordset to file and then kicking off a sqlcmd to kick off a batch file to import the data using sqlldr.