The problem is probably that you're not doing a bulk insert into Oracle (while you are doing a bulk insert into SQL Server, hence the performance difference).You can try the Attunity adaptors, they are free.

sqlbuddy123 (3/4/2014)Thought fast load was available for Oracle destination too. May be I missed it ..

--SQLBuddy

It depends on the OLE DB provider I think.It's possible the Microsoft OLE DB provider for Oracle (which is deprecated if I remember correctly) has a fast load option, but the Oracle OLE DB provider doesn't.

It depends on the OLE DB provider I think.It's possible the Microsoft OLE DB provider for Oracle (which is deprecated if I remember correctly) has a fast load option, but the Oracle OLE DB provider doesn't.